Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.
Versions of Excel up to 7.0 had a limitation in the size of their data sets of 16K (214 = 16384) rows.
Versions 8.0 through 11.0 could handle 64K (216 = 65536) rows and 256 columns (28 as label 'IV').
Version 12.0 can handle 1M (220 = 1048576) rows, and 16384 (214 as label 'XFD') columns.
My machine has Excel 2013. It has 65536 rows and 256 Columns.
The earlier versions of excel had fewer rows.
Hope this helps
Regards, Anna
It will depend on which Excel format or version we use.Suppose we work on Excel 2003 format there will be 65536 rows and 256 columns.On the other hand if we work on Excel 2007 version there are 1048576 rows and 16384 columns.
hello, its depends on the version of excel that you have.
for 2007 version, there are1048576 rows 16384 columns. 2003 excel has 65000+ rows
1,048,576 rows and 16,384 columns
1048576 rows and 16384 as label 'XFD' columns