Share via

my Excel 2010 only has 65,536 rows, how do I change that to the 1 million plus rows i'm supposed to have

Anonymous
2013-06-27T20:54:34+00:00

IS there a setting to change the number of rows - I only have the 65k rows, don't know how to get all the rows to appear.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

  1. Anonymous
    2013-06-27T23:06:47+00:00

    65536 is the maximum number of rows for the Excel 97-2003 file format.

    Any .xls files that you open will be limited to that number of rows.

    If you have specified that you want to save files in that format by default then when you create a new workbook it will be limited to 65536 rows and [compatibility mode] will appear in Excel's title bar.

    To change your default save format: File > Options > Save > Save fils in this format:

    Excel Workbook (*.xlsx)

    200+ people found this answer helpful.
    0 comments

3 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2015-04-21T17:33:42+00:00

    Hi Bill, this solution didn't work for me. When I went to the final screen, as directed, Excel Workbook was already chosen. What am I doing wrong?

    90+ people found this answer helpful.
    0 comments
  2. Anonymous
    2017-09-01T21:08:51+00:00

    Open a new workbook. Copy from the old workbook(s) and paste in new one. You will be able to paste beyond 65536 rows.

    20+ people found this answer helpful.
    0 comments
  3. Anonymous
    2013-06-28T13:52:17+00:00

    That was it - thanks for the answer.

    7 people found this answer helpful.
    0 comments