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.
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.
Why exactly that number?
- 1
Rows
2²⁰ = 1,048,576
- 2
Columns
2¹⁴ = 16,384 (A to XFD)
- 3
Total cells
≈ 17.2 billion
Answer
A 20-bit row counter and a 14-bit column counter
The takeaway
Every limit in computing is a power of two — because computers count in binary.