Managing Worksheets in Excel

At the bottom of an Excel workbook, you will find the Tab Management Area.

This area contains navigation arrows that can be used to move between tabs as well as between the created worksheets (shown as tabs). Here, you can copy, insert, rename or move a sheet within the Excel workbook.  

To reveal the tab actions, right-click on a tab.

Example shown here: right-click on the Sample Employee Data tab.

The Tab Actions pop-up menu is displayed.

To copy the selected worksheet, click the Move or Copy... menu option.

The Move or Copy pop-up box is displayed.

Select the worksheet you wish to copy from the list.

Example shown here: Sample Employee Data worksheet.

With the appropriate worksheet selected, click the Create a copy checkbox.

To confirm your selection, click the OK button.

The copied worksheet is displayed with a (2) next to the name to indicate it is the second sheet with that name.

To move a worksheet to your preferred location, right-click the appropriate tab in the Tab Management Area.

Example shown here: Sample Employee Data (2) tab.

The Tab Actions pop-up menu is displayed.

To move the selected worksheet, click the Move or Copy... menu option.

The Move or Copy pop-up box is displayed.

You can move the copied sheet to another workbook or before/after an existing sheet in the current workbook.

To move the selected worksheet to the end of the workbook, click the (move to end) option.

To confirm your selection, click the OK button.

The selected worksheet is moved.

Note: You can also click and drag a tab to the desired location in the Tab Management Area.

To add another worksheet, click the [+] button in the Tab Management Area.

The created worksheet is displayed.

To rename a worksheet, right-click the appropriate tab.

Example shown here: right-click Sheet 2 .

The Tab Actions pop-up menu is displayed.

To rename the selected worksheet, click the Rename menu option.

The selected worksheet tab is highlighted. It now works as a text field.

Enter the new name for the worksheet and press enter to save.

Example shown here: "Sample Employee List".

The new worksheet name is displayed.

To delete an existing worksheet from an Excel workbook, right-click the tab for the worksheet that you want to delete.

Example shown here:Sample Employee List tab.

A pop-up menu is displayed.

To remove the selected worksheet, click the Delete option.

To confirm removal of the selected worksheet, click the Delete button.

The selected worksheet has been deleted from the workbook.

To insert a template into the workbook, right-click a tab for a sheet.

Example shown here: right-click the Sample Employee Data (2) tab.

From the pop-up menu, click the  Insert... option.

The Insert pop-up menu is displayed, containing the General and Spreadsheet Solutions tabs. 

Example shown here: click the Spreadsheet Solutions tab.

From the Spreadsheet Solutions tab, click to select the appropriate template you wish to insert into your workbook.   

Example shown here: the Billing Statement template.

Click the OK button.

The selected template has been added to the workbook.