Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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

  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 10,593
Default 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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2007 rows & columns Jim[_3_] Excel Discussion (Misc queries) 3 July 1st 07 04:28 AM
Freezing multiple rows/columns in Excel 2007 Pro gary Excel Worksheet Functions 3 May 2nd 07 07:17 AM
excel template additional columns bobby02169 Setting up and Configuration of Excel 2 January 7th 07 04:55 PM
Rows and columns in 2007 1,048,576 rows by 16,384 columns Gene at Stonybrook Excel Worksheet Functions 1 September 26th 06 12:13 AM
How can I add additional rows beyond the 65,536 in excel 2003 pbhatt07 Excel Worksheet Functions 6 April 18th 06 11:20 PM


All times are GMT +1. The time now is 07:05 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"