When you’re working on a big project, you can spend so much time deep in your Excel workbook that it becomes an alternate universe. You can do a lot to make that workbook universe a comfortable place in which to work. Give your worksheets descriptive names—rather than Sheet 1, Sheet 2—to make them easy to recognize; reorganize them into a logical order; add new worksheets if you need to, or delete unused ones to get rid of any unnecessary clutter.
Name the Worksheets
Double-click a worksheet tab, type a descriptive name for the worksheet, and press Enter.
Repeat for any other worksheet tabs you’d like to rename.
Tip
To change the color of a worksheet tab, right-click the tab, choose Tab Color from the shortcut menu, and click the color you want in the gallery that appears.
Change Their Order
Click the tab of the worksheet you want to move.
Drag the tab to the desired location.
Insert a Worksheet
Click the Insert Worksheet button.
Rename the new worksheet, and move it to a different position among the tabs if you want.
Tip
To hide a worksheet from view instead of deleting it, right-click the tab, and choose Hide from the shortcut menu. To display the worksheet again, right-click a tab, choose Unhide from the shortcut menu, and, in the Unhide dialog box, select the worksheet to be displayed.
Delete a Worksheet
Right-click the tab for the worksheet you want to delete, and choose Delete from the shortcut menu.
When you’re asked to confirm the deletion, click Delete.