C Confused Mar 9, 2004 #1 Does anyone know the maxium number of cells, columns and rows a worksheet can contain?
F Frank Kabel Mar 9, 2004 #3 Hi have a look at the excel help (search for 'Specification): 65536 rows 256 columns max cells: 65536 * 256 No way around these limits
Hi have a look at the excel help (search for 'Specification): 65536 rows 256 columns max cells: 65536 * 256 No way around these limits
D David McRitchie Mar 9, 2004 #4 256 columns in all versions of Excel (column IV) 65,536 rows, some versions lower, no versions higher. Trying to use all of them will not work very well. If I try to run a macro on all cells in 2 columns it will take many minutes. HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
256 columns in all versions of Excel (column IV) 65,536 rows, some versions lower, no versions higher. Trying to use all of them will not work very well. If I try to run a macro on all cells in 2 columns it will take many minutes. HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
