Go Back   TechArena Community > Technical Support > Computer Help > Office Help > MS Office Support
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



Is it possible to have rows above 65,000 in Excel 2007

MS Office Support


Reply
 
Thread Tools Search this Thread
  #1  
Old 21-02-2012
Member
 
Join Date: Jan 2011
Posts: 12
Is it possible to have rows above 65,000 in Excel 2007

I am using excel 2007. In worksheet i have only 65,000 rows. I have heard that excel 2007 can provide over a million rows. Can some one help me on how to get all the rows (over a million rows) in excel 2007. Looking foward to hear from you.

Reply With Quote
  #2  
Old 21-02-2012
Member
 
Join Date: Aug 2011
Posts: 688
Re: Is it possible to have rows above 65,000 in Excel 2007

You can do that by Save as .xlsx; and try reopening the file. I do not know the exact way, but I think is the actual limitation of Excel. You can try a new spreadsheet in place of same.
Reply With Quote
  #3  
Old 21-02-2012
Member
 
Join Date: Aug 2011
Posts: 538
Re: Is it possible to have rows above 65,000 in Excel 2007

Or esle there is one more thing you can try. Click on Office button > Excel Options > "Save" section - make sure the top dropdown doesn't say ".xls", but says ".xlsx" or ".xlsm" etc. All new workbooks will not have 1048576 rows. If you're opening a file which was created in 2003 or earlier, then you still will get 65536 rows. To increase this yuo need to convert it to 2007: Office button/Convert.
Reply With Quote
Reply

  TechArena Community > Technical Support > Computer Help > Office Help > MS Office Support
Tags: , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Is it possible to have rows above 65,000 in Excel 2007"
Thread Thread Starter Forum Replies Last Post
How to break rows in Excel 2007 connoisseur MS Office Support 2 17-02-2012 05:22 PM
Hiding rows in Excel 2007 using macros sam007 Windows Software 3 16-10-2009 01:57 PM
Merging duplicate names not rows copy rows into new workbook each time VBA Excel 2003 awkwardsmile Software Development 2 09-07-2009 08:57 AM
How do i automatically number rows in Excel 2007 Atilla Windows Software 3 21-04-2009 10:48 AM
Auto hide rows and column in Excel 2007 Murena Windows Software 3 28-02-2009 06:00 PM


All times are GMT +5.5. The time now is 10:01 AM.