View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default Need to expand Excel 2007 spreadsheet beyond column IV

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

On Jan 17, 1:18*am, DoDMgmtPogue
wrote:
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....