Table name a name of an Excel table that is created automatically when you insert a table in a worksheet (Ctrl T) For more information about Excel tables, please see How to make and use a table in ExcelSheet Names and Table Names Followed by ! Once you name your tables, you can simply type those table names in your formulas and references Best of all, if the table changes with new rows or columns, these references are smart enough to update as well Table names are a must when you create large, robust Excel workbooks It's a housekeeping step that ensures you know where your cell references point to How to Make Cleaner Excel
Total The Data In An Excel Table
