Archive of Mr Excel Message Board
Back to General Excel archive index
Back to archive home
Maximum # of RowsPosted 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 RowsPosted 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 RowsPosted 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
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.