Excel 2016 Managing Worksheets

Lesson 1 – Working with Multiple Worksheets

Excel 2016

3. Select the arrow on the right-hand part of the Insert button . 4. Select the Insert Sheet command.



S TEP - BY -S TEP Insert a worksheet before another worksheet.

Steps

Practice Data

1. Select the worksheet to the left of which you want to insert a new worksheet. The worksheet is selected.

Click the April worksheet

2. Select the Home tab.

Click Home

The Home tab is displayed.

3. Select the arrow on the right-hand part of the Insert button. The Insert menu opens. 4. Select the Insert Sheet command. The inserted worksheet appears to the left of the active worksheet.

Click

Click Insert Sheet

Rename the new worksheet Qtr 1 .

D ELETING W ORKSHEETS  D ISCUSSION

You can delete unwanted worksheets. For example, you can delete a worksheet used for temporary calculations. When you delete a worksheet, the entire worksheet and the data it holds are permanently removed from the workbook.

NOTE If you select multiple worksheets, multiple worksheets are deleted. If the worksheet you are deleting contains data, you will be prompted to confirm the deletion. You will not be prompted for a blank worksheet. You cannot Undo the deletion of a worksheet(s).

Page 10

OFFICEPRO, Inc.