A structured data range that enables automatic formatting, filtering, and dynamic referencing.
Pruébalo con IAAn Excel Table (ListObject) is a feature that turns a standard range of cells into a formal data object. It automatically applies formatting, adds filter controls to headers, and uses structured references instead of cell addresses in formulas.
When you convert a range to a table, a formula like '=SUM(A2:A10)' becomes '=SUM(Table1[Sales])', which automatically updates as you add new rows.
Select your data range and press Ctrl+T, or go to the Insert tab and click Table.