Microsoft Excel 2016 – Speed up tasks with the Sheet Tab Bar

The Sheet Tab Bar lets you add more worksheets (and other types of sheets, such as a chart sheet, macro sheet, or dialog sheet), rename them, move them, or delete them. You can even quickly change the colour of a tab.

Note: The name (or title) of a worksheet appears on its sheet tab at the bottom of the screen. By default, the name is Sheet1, Sheet2, and so on, but you can give any worksheet a more appropriate name. 

To Insert a new worksheet 

Click the New sheet button at the bottom of the screen, to the right of tabs--little “+” sign inside the circle.

On the Sheet tab bar, right-click a sheet tab, then click Insert, then choose a General or Spreadsheet Solutions tab in the pop-up box

To insert a new worksheet in front of (to the left of) an existing worksheet

From the ribbon select the existing worksheet and then, click Home > Insert > Insert Sheet.

To Rename a worksheet

On the Sheet tab bar, right-click the sheet tab that you want to rename, and then click Rename, select the current name, and then type the new name.

To Move or Copy a worksheet

To change the order of the worksheets in a workbook, click the tab of the worksheet that you want to move, and then drag it to the location that you want.

To Delete a worksheet

Right-click the sheet tab of a worksheet that you want to delete, and then click Delete Sheet.

Select the worksheet or worksheets that you want to delete, click Home, click the arrow below Delete, and then click Delete Sheet.

Tips:

Sheet tabs appear automatically. If you don't see them, click File > Options > Advanced > Show sheet tabs.

When you select multiple worksheets, [Group] appears in the title bar at the top of the worksheet. To cancel a selection of multiple worksheets in a workbook, click any unselected worksheet. If no unselected sheet is visible, right-click the tab of a selected sheet, and then click Ungroup Sheets on the shortcut menu.

You can include the name of the sheet when you print the worksheet.

a. Click Insert > Header & Footer.

b. In the Page Layout View, click the location where you want the sheet name to appear.

c. In the Header & Footer elements group, click Sheet Name Button image.