MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Maximum # of Rows


Posted by scott on December 13, 2001 11:17 AM

Does anyone know the maximum amount of rows and/or columns that excel can handle (ie- how many rows of data can excel handle? 10,000? 15,000? etc. Thanks in advance

Posted by Juan Pablo G. on December 13, 2001 11:22 AM

You can check this yourself, hit [Ctrl Down] and then [Ctrl Right], you should be at cell IV65536, that is, 65,536 rows x 256 columns.

Juan Pablo G.

Posted by Jack on December 13, 2001 12:17 PM

Far right is 256 cells along column IV
far down is 65536 cells down row 65536

We use ABC and 123 for easy so cells are A1 to IV65356 and any inbetween

HTH
JACK