Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Is there a limit? I couldn't find one posted.

share|improve this question
add comment

3 Answers

up vote 32 down vote accepted

Have a look at this link (and this for 2013). A quick summary:

+-----------------+-----------+--------------+---------------------+
|                 | Max. Rows | Max. Columns | Max. Cols by letter |
+-----------------+-----------+--------------+---------------------+
| Excel 365*      | 1,048,576 | 16,384       | XFD                 |
| Excel 2013      | 1,048,576 | 16,384       | XFD                 |
| Excel 2010      | 1,048,576 | 16,384       | XFD                 |
| Excel 2007      | 1,048,576 | 16,384       | XFD                 |
| Excel 2003      | 65,536    | 256          | IV                  |
| Excel 2002 (XP) | 65,536    | 256          | IV                  |
| Excel 2000      | 65,536    | 256          | IV                  |
| Excel 97        | 65,536    | 256          | IV                  |
| Excel 95        | 16,384    | 256          | IV                  |
| Excel 5         | 16,384    | 256          | IV                  |
+-----------------+-----------+--------------+---------------------+

*Excel 365 unverified.

share|improve this answer
add comment

You can find out how many rows your version of Excel supports by opening a new file in Excel then pressing CTRL + Down Arrow in an empty worksheet.

This number of rows can be saved in the default format that version of Excel supports (e.g. XLSX).

However, you will not necessarily be able to save in the older XLS format, which is still limited to 65,536 rows. Typing in a cell in row number 1048576 (e.g. A1048576) then saving to XLS format will cause a warning. If you close and re-open this file, you will then find this cell empty.

share|improve this answer
add comment

Doing a web search for "maximum number of rows in Excel" gives a link (several, actually) with

Starting in Excel 2007, the "Big Grid" increases the maximum number of rows per worksheet from 65,536 to over 1 million, and the number of columns from 256 (IV) to 16,384 (XFD).

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.