ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Additional Rows and Columns in Excel 2007 (https://www.excelbanter.com/excel-discussion-misc-queries/150701-additional-rows-columns-excel-2007-a.html)

Debra Lassman

Additional Rows and Columns in Excel 2007
 
I have installed Office 2007 on my machine and when I open Excel 2007 I still
have 256 columns and 65,536 rows. I know in the 2007 version that you have
the ability to have more than this. If I add new rows and colulmns it will
not insert any additional ones. If I open a workbook that someone else has
created in Excel 2007 I see over 1,000,000 rows and more than 256 columns.

How do I add these additional rows to my new workbooks in 2007?

Thanks,
Debra Lassman


Bob Phillips

Additional Rows and Columns in Excel 2007
 
The workbook is being open in 2003 compatibility mode.

Click the Office button and select convert. You will need to save the file
as a .xlsx or .xlsm file type.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Debra Lassman" wrote in message
...
I have installed Office 2007 on my machine and when I open Excel 2007 I
still
have 256 columns and 65,536 rows. I know in the 2007 version that you have
the ability to have more than this. If I add new rows and colulmns it will
not insert any additional ones. If I open a workbook that someone else has
created in Excel 2007 I see over 1,000,000 rows and more than 256 columns.

How do I add these additional rows to my new workbooks in 2007?

Thanks,
Debra Lassman





All times are GMT +1. The time now is 06:28 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com