Organizing Your Worksheets

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

  1. Double-click a worksheet tab, type a descriptive name for the worksheet, and press Enter.

  2. Repeat for any other worksheet tabs you’d like to rename.

    Name the Worksheets

Tip

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

  1. Click the tab of the worksheet you want to move.

  2. Drag the tab to the desired location.

    Change Their Order

Insert a Worksheet

  1. Click the Insert Worksheet button.

  2. Rename the new worksheet, and move it to a different position among the tabs if you want.

    Insert a Worksheet

Tip

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

  1. Right-click the tab for the worksheet you want to delete, and choose Delete from the shortcut menu.

  2. When you’re asked to confirm the deletion, click Delete.

    Delete a Worksheet
..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset