Need to expand Excel 2007 spreadsheet beyond column IV

[DoDMgmtPogue]

I read on this forum that prior to Excel 2007 spreadsheets were limited to
256 columns (Column IV was max). Several users got chastized for even asking
how to go beyond column IV. On the other hand, sometimes it really is needed.

So, how do I get Excel 2007 to go beyond column 256? I really need to...

 

[Pete_UK]

You need to save the file with an extension of .xlsx (using the file
type panel) rather than .xls, and when you open that file again it
will have the larger range (16,000 + columns)

Hope this helps.

Pete

 

[Deepali Joshi]

Hi,

when open the file in 2007 which is created in 2003, always it shows 256
rows as it is the limit of 2003. if you want to get the rows beyond the limit
of 256, then save the file in 2007 format i.e. with xlsx file extention.


Deepali Joshi