Columns limit

[mazorj]

In Excel 2003 I'm bumping up against a limit at Column IV, or 204 columns in
a yearly stock pricing spreadsheet. I need one more column to do year-end
sums.

First, is there any way to get more columns?

Second, why 204? I'm only doing entries for stock market trading days, so
204 is almost enough. But what if you want to record 365 daily entries?
(Yeah, you can do it vertically but that's not the optimal way to display
data like this.)

TIA for any help.

 

[Dave Peterson]

xl2003 and below have 256 columns. xl2007 has 16k columns.

There's nothing you can do to xl2003 to add more columns.

 

[Pete_UK]

From Column A to Column IV is 256 columns - do you have some columns
hidden that you are not counting?

If you really need more than 256 columns then you will have to think
about using another sheet for the extra columns, or you could upgrade
to XL 2007 which has up to 16k columns per sheet.

Hope this helps.

Pete

 

[Bob Umlas]

Upgrade to Excel 2007 - 16384 columns (and 1048576 rows)