Results 1 to 3 of 3

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

  1. #1
    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.

  2. #2
    Join Date
    Aug 2011
    Posts
    700

    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.

  3. #3
    Join Date
    Aug 2011
    Posts
    542

    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.

Similar Threads

  1. How to break rows in Excel 2007
    By connoisseur in forum MS Office Support
    Replies: 2
    Last Post: 17-02-2012, 05:22 PM
  2. Hiding rows in Excel 2007 using macros
    By sam007 in forum Windows Software
    Replies: 3
    Last Post: 16-10-2009, 01:57 PM
  3. Replies: 2
    Last Post: 09-07-2009, 08:57 AM
  4. How do i automatically number rows in Excel 2007
    By Atilla in forum Windows Software
    Replies: 3
    Last Post: 21-04-2009, 10:48 AM
  5. Auto hide rows and column in Excel 2007
    By Murena in forum Windows Software
    Replies: 3
    Last Post: 28-02-2009, 06:00 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •