Microsoft Office Tutorials and References
In Depth Information
Referencing data in a table
The at symbol ( @ ) that precedes the column header represents “this row.” So, [@Actual] means “the value in the
Actual column in this row.”
These steps use the pointing technique to create the formula. Alternatively, you could have
entered the formula manually using standard cell references rather than column headers.
For example, you could have entered the following formula in cell E3:
If you type the cell references, Excel will still copy the formula to the other cells
One thing should be clear, however, about formulas that use the column headers instead of
cell references: They’re much easier to understand.
When you add a formula to a column in a table, Excel displays the AutoCorrect Options button. To override the
automatic column formulas, click the button and click Stop Automatically Creating Calculated Columns. Use this option if
you need different formulas for different rows within the table.
Referencing data in a table
Excel offers some other ways to refer to data that’s contained in a table by using the table
name and column headers.
Remember that you don’t need to create names for tables and columns. The data in the table itself has a range
name, which is created automatically when you create the table (for example, Table1 ), and you can refer to data
within the table by using the column headers — which are not range names.
You can, of course, use standard cell references to refer to data in a table, but using the
table name and column headers has a distinct advantage: The names adjust automatically
if the table size changes by adding or deleting rows. In addition, formulas that use table
names and column headers will adjust automatically if you change the name of the table or
give a new name to a column.
Search JabSto ::

Custom Search