Expanding column count

  • Thread starter Thread starter mazorj
  • Start date Start date
M

mazorj

In Excel 2003 the last column in a sheet is fixed when you first save
the new file. The last column in my spreadsheet has data so Excel
won't allow Insert to add a column at the end. Is there another way
to add one more blank column at the end of an existing sheet?
 
You'll have to delete a column between your "real" data and the last column.
Then insert a new column.

Is there a reason you're using the last column? Maybe you could move that to
column A. If you don't like seeing the stuff in that column, you could hide
column A, too.
 
The last column in an Excel 2003 worksheet is always column IV.........256
columns. Has no relation to saving.

This cannot be changed..................no more columns can be added to a
sheet or columns inserted if you have data in column IV

If your project requires more, upgrade to Excel 2007 which has 16384
columns.


Gord Dibben MS Excel MVP
 
Thanks, I had already installed Office 2007 and was planning on doing
my 2010 sheet on it. I was sticking to Excel 2003 for the remainder
of the 2009 sheet created under it because there doesn't seem to be
any advantage to opening it in Excel 2007. When I open it in Excel
2007 it still seems to carry the column limitation at Column IV.

Am I missing something with Excel 2007? Can it add more columns to
this sheet?
 
Gord Dibben said:
The last column in an Excel 2003 worksheet is always column
IV.........256
columns. Has no relation to saving.

This cannot be changed..................no more columns can be added
to a
sheet or columns inserted if you have data in column IV

If your project requires more, upgrade to Excel 2007 which has 16384
columns.

Gord Dibben MS Excel MVP
Click to expand...

Thank you. That already was in the mill for my 2010 sheet.
 
Pete_UK said:
Save that file as .xlsx file, close the file then re-open it.

Hope this helps.
Pete
Click to expand...

Doh! Should have thunk of that myself. Merely opening the file in
Excel 2007 didn't allow that, but saving it as an .xlsx and reopening
it did. Thanks.
 
Dave Peterson said:
You'll have to delete a column between your "real" data and the last
column.
Then insert a new column.

Is there a reason you're using the last column? Maybe you could
move that to
column A. If you don't like seeing the stuff in that column, you
could hide
column A, too.
Click to expand...

Column A identifies each line, and the next two columns have data used
in all the subsequent daily columns. I need Col. A and moving the
next two would be a pain because many of the daily calculations refer
back to them as fixed $X$Y cells. The last column currently is marked
for Dec. 31. I see now that saving it as an .xlsx file allows me to
add columns, so problem solved. Thanks for the suggestion.
 
Back
Top