Before Excel 2007, a worksheet had only 65,536 rows.

Wacky WorldExcel & Office

The old .xls format capped sheets at 65,536 rows and 256 columns (IV). Excel 2007’s .xlsx format raised it to 1,048,576 rows and 16,384 columns — 1,024 times more cells.

Another wacky fact → All facts

Explore more Excel & Office facts

Excel stores every date as a number.Excel quietly supports a function it does not list: DATEDIF.Excel has 1,048,576 rows — exactly 2 to the power 20.