Set cell values equal to all sheet names with Kutools for Excel If you want to make a list of cell values equal to all of the tab names, you can apply the CreateGo 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 Excel will create a name, and it's easy to change the pivot table name at any time Watch this video to see the steps for creating a pivot table, using the
Create Format Resize And Rename Excel Tables Excel Quick Help
