The references can make it easier to locate tables in a large workbook. Structured references also appear when you create a formula outside of an Excel table that references table data. The names in structured references adjust whenever you add or remove data from the table. That combination of table and column names is called a structured reference. ![]() ![]() Instead of using explicit cell references ![]() When you add formulas to an Excel table, those names can appear automatically as you enter the formula and select the cell references in the table instead of manually entering them. When you create an Excel table, Excel assigns a name to the table, and to each column header in the table.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |