Changing number of available columns & rows

O

Otto Moehrbach

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
 
T

T. Valko

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.
 
D

Dave Peterson

Save the file as a normal workbook (or .xlsx (no macros) or .xlsm (with
macros)).

Close the file and reopen that newly saved version--not the .xls version.

If you look at the titlebar, you should see (or not see) the Compatibility mode
indicator.
 
G

Gord Dibben

Save the workbook as Excel 2007.

If new workbooks are all 65536 rows and 256 columns you may have a BOOK.XLT
in your XLSTART folder left over from Excel 2003.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Merging multiple columns into one column (dynamically) 1
Excel 2007 2
counting blank cells within two columns 2
Where are the extra columns and rows? 6
Pivot Table Wizard Fails to Recognize New Rows of Database 2
Excel Visual Basic to get current row number 1
Excel 2007 SP1 - How to correct scrollbar extent? 1
Changing Row Height/Column Width 4

Top