Archive of Mr Excel Message Board

Back to General Excel archive index
Back to archive home

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

Re: Maximum # of Rows

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.

Re: Maximum # of Rows

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

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.