I've inherited a spreadsheet that has an ending column labeled as IV--somehow
everything after that column was deleted. This spreadsheet is used to track
my staff's daily time activity for the year and I need a column for each
workday. It currently ends in the middle of October. I need to add/insert
columns for the rest of October, November, and December. I'm trying to
insert new columns, but I keep getting the message: Excel cannot shift
nonblank cells off the worksheet. I've followed the instructions to delete
the rows and columns from my last nonblank cell to the end of the spreadsheet
(column and row), but I'm still getting the message. Any suggestions?

The column labeled IV is the last column of the workbook. Up till Excel 2003
you get 256 rows and IV is the last.

You might try using a new worksheet in the new workbook, using a new
workbook, or upgrading to Excel 2007, which gives up to 16,000 colums.

Did you import the worksheet from another program?

"Kary P." wrote:

> I've inherited a spreadsheet that has an ending column labeled as IV--somehow
> everything after that column was deleted. This spreadsheet is used to track
> my staff's daily time activity for the year and I need a column for each
> workday. It currently ends in the middle of October. I need to add/insert
> columns for the rest of October, November, and December. I'm trying to
> insert new columns, but I keep getting the message: Excel cannot shift
> nonblank cells off the worksheet. I've followed the instructions to delete
> the rows and columns from my last nonblank cell to the end of the spreadsheet
> (column and row), but I'm still getting the message. Any suggestions?

If you are using Excel 2003 (or earlier) then IV (column 256) is the last
column
With Excel 2007 (or the free-for-now Excel 2101 beta) you can have 16,365
columns
Of course, opening an Excel 2003 file in Excel 2007 (compatibility mode)
also enforces the 256 limit
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"Kary P." <Kary P.@discussions.microsoft.com> wrote in message
news:A05A43C6-B181-423D-9498-(E-Mail Removed)...
> I've inherited a spreadsheet that has an ending column labeled as
> IV--somehow
> everything after that column was deleted. This spreadsheet is used to
> track
> my staff's daily time activity for the year and I need a column for each
> workday. It currently ends in the middle of October. I need to
> add/insert
> columns for the rest of October, November, and December. I'm trying to
> insert new columns, but I keep getting the message: Excel cannot shift
> nonblank cells off the worksheet. I've followed the instructions to
> delete
> the rows and columns from my last nonblank cell to the end of the
> spreadsheet
> (column and row), but I'm still getting the message. Any suggestions?