View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Bernard Liengme[_2_] Bernard Liengme[_2_] is offline
external usenet poster
 
Posts: 563
Default How to add columns to the end of a spreadsheet--(last col is IV)?

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 wrote in message
...
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?