View original (French)

Increase the number of rows in Excel

Alfred -  
Raymond PENTIER Posted messages 58546 Registration date   Status Contributeur Last intervention   -
Hello,

I'm working in Excel 2013, but I see the number of rows is limited to only 65,536, while I need more than 1,900,000 rows. What should I do? I'm a bit stuck. Could you help me?
Configuration: Windows / Internet Explorer 11.0

1 réponse

Réponse 1 / 1
jc80 Posted messages 5063 Registration date   Status Membre Last intervention   1 442
 
Hello

Number of rows and columns in Excel
Excel Version Number of Rows Name of the Last Column
Excel 2003 65,536 (= 216) IV
Excel 2007 1,048,576 (= 220) XFD
Excel 2010 1,048,576 (= 220) XFD
Excel 2013 1,048,576 (= 220) XFD

Best regards
-1
Alfred
 
Good evening,

Thank you very much for your response. Even though I was working in Excel 2013, I eventually found that the file was saved in Excel 2003. Hence, the number of rows was limited to only 65,536. Now, after changing this type of Excel, I have a sufficient number of rows to work comfortably.

Thank you very much.
0
Raymond PENTIER Posted messages 58546 Registration date   Status Contributeur Last intervention   17 474
 
However, you said you needed 1,900,000 lines...
So you're going to be short by almost half (850,000).
So be prepared to split your table across 2 sheets, or to delete empty rows, or to combine 2 rows of data related to the same reference into a single row, etc...
0