View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default How to add columns to the end of a spreadsheet--(last col is IV)?

IV is as far as it goes in Excel 2003. 256 columns is the limit. If you
need more columns, it needs Excel 2007.
--
David Biddulph


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?