Excel 2016 Managing Worksheets

Excel 2016

Lesson 1 – Working with Multiple Worksheets



P ROCEDURES

1. Right-click the tab of the worksheet you want to delete. 2. Select the Delete command.

3. Select the Delete button

, if prompted.



S TEP - BY -S TEP

Delete a worksheet.

Scroll to display the last worksheet in the workbook.

Steps

Practice Data

1. Right-click the tab of the

Right-click the Annual tab

worksheet you want to delete. A shortcut menu opens.

2. Select the Delete command. A Microsoft Excel message box opens.

Click Delete

3. Select Delete , if prompted.

Click

The Microsoft Excel message box closes, and the worksheet is deleted.

P RINTING S ELECTED W ORKSHEETS  D ISCUSSION

You can print some or all of the worksheets in a workbook. For example, in an annual workbook containing monthly worksheets, you may want to print only the worksheets for the most recent months.

When printing one or more worksheets instead of the entire workbook, you must select the worksheets you want to print before opening the Print dialog box.

OFFICEPRO, Inc.

Page 11