View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default Changing number of available columns & rows

If you open a file in xls format from an earlier version of Excel then you
only get 255 columns / 65536 rows. You'd have to open the file then do a
save as in one of the Excel 2007 formats. The next time you open the file
you'll get all the rows/columns in Excel 2007.

--
Biff
Microsoft Excel MVP


"Otto Moehrbach" wrote in message
...
My Excel 2007 is set to the same number of columns & rows as prior
versions. How do I change that? Thanks for your time. Otto