You are here LEARN EXCEL & VBA Microsoft Excel 2007 Tutorials Developing a Workbook

Developing a Workbook

Format Worksheet Tab
You can rename a worksheet or change the color of the tabs to meet your needs.
To rename a worksheet:

  • Open the sheet to be renamed
  • Click the Format button on the Home tab
  • Click Rename sheet
  • Type in a new name
  • Press Enter

Rename Sheet Drop Down

To change the color of a worksheet tab:

  • Open the sheet to be renamed
  • Click the Format button on the Home tab
  • Click Tab Color
  • Click the color

Tab Color Drop Down Menu

Reposition Worksheets in a Workbook
To move worksheets in a workbook:

  • Open the workbook that contains the sheets you want to rearrange
  • Click and hold the worksheet tab that will be moved until an arrow appears in the left corner of the sheet
  • Drag the worksheet to the desired location

Move Worksheet

Insert and Delete Worksheets
To insert a worksheet

  • Open the workbook
  • Click the Insert button on the Cells group of the Home tab
  • Click Insert Sheet

Insert Sheet Drop Down Menu

To delete a worksheet

  • Open the workbook
  • Click the Delete button on the Cells group of the Home tab
  • Click Delete Sheet

Delete Worksheet Drop Down Menu

Copy and Paste Worksheets:
To copy and paste a worksheet:

  • Click the tab of the worksheet to be copied
  • Right click and choose Move or Copy
  • Choose the desired position of the sheet
  • Click the check box next to Create a Copy
  • Click OK

Move or Copy Right-Click Menu