Communiquez avec les autres et partagez vos connaissances professionnelles

Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.

Suivre

How many rows and columns in Microsoft excel?

user-image
Question ajoutée par Imad Gul , Web Developer , Amana Advertising
Date de publication: 2017/05/21
Syed Hunain Raza Jafri Jafri
par Syed Hunain Raza Jafri Jafri , IT Engineer , Alec

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.

Anna Hayes
par Anna Hayes , Director , Juniper Engineering Services Ltd

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

md saood manzar
par md saood manzar , Lab Researcher Air Pollution Lab , university of dammam

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.

 

 

abisoye Sonubi
par abisoye Sonubi , Information Security/ Risk specialist , Ecobank Nigeria Limited

hello, its depends on the version of excel that you have.

for 2007 version, there are1048576 rows 16384 columns. 2003 excel has 65000+ rows

Hummera Hussain
par Hummera Hussain , Vice principal , Iqbalian superior school

1048576 rows 16384 columns in 2007

balqis al jassmi
par balqis al jassmi , Senior Executive , Dubai police

1,048,576 rows and 16,384 columns 

Junaid Zia
par Junaid Zia , Public relation officer , Very Easy Documents Clearing Services

1048576 rows and 16384 as label 'XFD' columns

More Questions Like This