Forum Discussion

Haytham Amairah's avatar
Haytham Amairah
Silver Contributor
Apr 22, 2017

Excel Worksheet Size Limits

Why the maximum limit of Excel worksheet size is:

1,048,576 rows by 16,384 columns

 

I noticed that the result of this calculation is the same number of the maximum rows:

 

1024 * 1024 = 1048576

.

Is this related?

excel

1 Reply

Sort By
  • Detlef_Lewin's avatar
    Detlef_Lewin
    Silver Contributor
    Apr 22, 2017

    Hello Haytham

     

    The numbers can all be calculated with base 2.

     

    Before Excel 2007 Excel used 65536 rows and 256 columns.

    Since Excel 2007 that has changed to 1048576 rows and 16384 columns

     

     

     A
    165536
    2256
    31048576
    416384

     

    CellFormula
    A1=2^16
    A2=2^8
    A3=2^20
    A4=2^14
    Diese Tabelle wurde mit Tab2Html (v2.4.1) erstellt. ©Gerd alias Bamberg

Resources