Easier Table References in Excel - EQ 92

Some simple tips to make table references easier in Excel, even when you don't remember the name of the table or its columns.

This little trick shows off some of Excel's auto-complete type features for formulas and also a great tip for naming your tables so that its always easy to reference them in your formulas.

Additional Resources

Excel Courses:

#msexcel #excelquickie #tutorial

[wayneedmondson]

Nice one! Structured referencing for tables can be confusing, until you learn the rules. Thanks for the tips :)) Thumbs up!!

[JohnYoga]

Thank you, Thank you, Thank you. My God, I couldn't figure this out.

[darrylmorgan]

Great Tips!Always Name Tables It Makes Life So Much Easier...Thank You Sir :)

[shoaibtahir]

What do to if we want to display all the values in that column?
Like displaying the entire 'Weekends' column in table 'TblRow' starting on other sheet?

[jerrydellasala]

When using table references, if you use a standard table reference as shown, when you drag to copy the formula, the table reference is not fixed, so selecting the sample AVERAGE cell and dragging it to the right to copy the formula results in the copied formulas to follow the sequence in the table (Discount %, Total, Store ID). Occasionally I've wanted to use a fixed reference (without turning off structured references) so that the formula can be dragged/copied without changing the (column) reference. In this case the formula would be
=AVERAGE(TblRaw[[Qty]:[Qty]])
which, when dragged/copied in any direction would not change. Why MS hasn't set up the F4 key to automatically fix a table reference the way it does for cell references I don't understand. A quick video of how that works would be helpful.

[Innerslaught]

how do i locate where a table is, which is used in a formula, in an excel workbook that contains multiple sheets, in a structure reference, where the formula is in the different sheet with the table being referred to?

[oinkpiggin]

How do I trace back to the table ? If someone is new to the table and they see tblraw, how do they know where that is in 50 sheets ?

[bardia]

Wtf. Idk why I can't reference table names in my formulas... I made a table and named it but I can't reference it in formulas