Changing number of available columns & rows
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 |
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 |
Changing number of available columns & rows
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. Otto Moehrbach wrote: 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 -- Dave Peterson |
Changing number of available columns & rows
Typo:
255 columns Should be: 256 columns -- Biff Microsoft Excel MVP "T. Valko" wrote in message ... 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 |
Changing number of available columns & rows
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 On Mon, 2 Nov 2009 13:57:53 -0500, "Otto Moehrbach" wrote: 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 |
Changing number of available columns & rows
Thanks guys. I think I had my brain turned off. Otto
"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 |
All times are GMT +1. The time now is 06:50 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com