Goal: Reference data by Name, not Address.
Excel Tables allow you to use readable names like [@Price] instead of abstract coordinates like B2.
fxSelect a mode...
Item
Price
Total
Apple
1.00
-
Banana
0.50
-
Cherry
2.00
-
Ready...
💻 Formula Structure
=[@Price] * 2
[@Column]: Refers to the cell in "This Row" of that column.
Benefit: Reads like plain English. Auto-fills down the entire column.
=B2 * 2
B2: Standard reference.
Drawback: Harder to read. Doesn't automatically fill new rows if the table expands.
=SUM(Table1[Price])
Table1[Price]: Refers to the ENTIRE data column (excluding header).
Benefit: Dynamic ranges. If you add rows, the SUM automatically includes them.
-- Current Operation
...
Visual:
-
⚠️ Syntax Tip
🔠 Using Space
If a column name has a space (e.g., "Unit Price"), you MUST use brackets: [Unit Price]. If no space, brackets are still good practice but strictly required only for special chars.