Excel's grid feels like an endless canvas until you hit the boundaries of row 1,048,576 or column XFD. These limits aren't random—they're digital walls shaped by history, hardware, and binary logic.

Some of Excel’s most powerful modern features simply do not work inside tables. Dynamic array formulas, often called spill formulas, break the table model because their results are not confined to a ...