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?
|