How to add columns to the end of a spreadsheet--(last col is IV)?

K

Kary P.

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

Anthony Fontana

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

David Biddulph

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

Bernard Liengme

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top