To rename a table: Click on the table. Go to Table Tools > Design > Properties > Table Name. On a Mac, go to the Table tab > Table Name. Highlight the table name and enter a new name.

If you modify a defined name or table name, all uses of that name in the workbook are also changed. In the Name Manager dialog box, double-click the name you want to edit, or, click …

When you create an Excel table, Excel creates a default table name (Table1, Table2, and so on), but you can change the table name to make it more meaningful. Select any cell in the table to …

Excel provides numerous predefined table styles that you can use to quickly format a table. If the predefined table styles don't meet your needs, you can create and apply a custom table style.

After you create an Excel table in your worksheet, you can easily add or remove table rows and columns. You can use the Resize command in Excel to add rows and columns to a table:

You can quickly change the Custom Name of a field or item without displaying the Field Settings or Value Field Settings dialog boxes. Renaming a numeric item changes it to text, which sorts …

Learn about the many ways to create a table in an Excel worksheet, and how to clear data, formatting, or table functionality from a table in Excel. Discover more in this video.

To edit the contents of a data label, click two times on the data label that you want to change. The first click selects the data labels for the whole data series, and the second click selects the …

In Excel for the web, you can use the named ranges you've defined in Excel for Windows or Mac. Select a name from the Name Box to go to the range's location, or use the Named Range in a …

When you create a PivotTable or PivotChart, Excel assigns default names to each of these objects by using the following naming conventions: PivotTable1, PivotTable2, and so on; and …