Most spreadsheet problems come from static cell ranges—Excel tables replace them with dynamic, self-managing data structures.

In Microsoft Excel and other popular modern spreadsheet programs, text and numbers are displayed in a rectangular grid of cells. Generally, every cell in a row or column has the same size, so you ...