Excel will enter structured references automatically when you reference parts of a table with point and click. This behavior is controlled by the preference “Use table names in formulas”.
Examples
To get the total rows or columns in an Excel table: To count or sum items in a column: To count visible rows in a filtered table:
Current row
Inside an Excel table, you’ll see the following syntax for “current row”:
Absolute references
References to single columns in a table are relative by default - when formulas are copied across columns, you’ll see the column references change. References to multiple columns are absolute and will not change when formulas are copied. Author
Dave Bruns
Hi - I’m Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.
