Page 70 - Code & Click - 5

WORKING WITH WORKSHEETS

By default, each workbook in Excel 2016 contains one
worksheet. The worksheet currently open in a workbook
is called an Active worksheet.
To insert a new worksheet:

1. Click the worksheet tab before which you want
to insert a new worksheet. 1
2. On the Home tab, click the Insert button in the Cells group.
A drop-down list appears.

2

3

3. Click the Insert Sheet option.
A blank worksheet is inserted before the current worksheet.

Roundabout Subject Enrichment

Click the New sheet button next to the worksheet tab to insert a worksheet after the
current worksheet.

To rename a worksheet:
1. Click the worksheet tab you want to rename.

2. On the Home tab, click the Format button in the Cells group. 2
A drop-down list appears.

1

3. Under Organize sheets, click the Rename Sheet option. 3
4. Type the new name for the worksheet and press the Enter key.

Excel assigns the new name to the worksheet.

4

68