Real World Maths Busters

The Maths Behind Everyday Life

The story, the formula and a worked example — see exactly where this maths shows up in the world around you.

Back to all stories
Technology 3 min read

Why Excel Crashes on a Million Rows

The grid has 1,048,576 rows — exactly 2²⁰.

Excel’s row limit is 2²⁰ = 1,048,576. That number is not arbitrary — it is a power of two, the natural unit for computers.

Row limit

Excel uses 20 bits to address rows: 2²⁰ possible values.

220=1,048,5762^{20} = 1{,}048{,}576

Why exactly that number?

  1. 1

    Rows

    2²⁰ = 1,048,576

  2. 2

    Columns

    2¹⁴ = 16,384 (A to XFD)

  3. 3

    Total cells

    ≈ 17.2 billion

Answer

A 20-bit row counter and a 14-bit column counter

The formula behind it

Exponent

2n2^n
See the full formula, variables and more examples

The takeaway

Every limit in computing is a power of two — because computers count in binary.

Back to all stories