Excel 2016 Managing Worksheets

Lesson 1 – Working with Multiple Worksheets

Excel 2016

Steps

Practice Data

1. Double-click the worksheet tab you want to rename. The worksheet name is selected.

Double-click the Sheet11 tab

2. Type the desired worksheet name.

Type November

The worksheet name appears on the tab.

3. Press [Enter] .

Press [Enter]

The worksheet name changes.

Practice the Concept: Rename Sheet 12 to December.

S ELECTING M ULTIPLE W ORKSHEETS  D ISCUSSION

Before you can apply a command to a worksheet, you must select the worksheet. If you select multiple worksheets, you can apply a command to all the worksheets at the same time. For example, you can copy, move, delete, and print all the worksheets in a selected group at the same time. In addition, when you insert new sheets, the number of sheets you select determines the number of sheets inserted.

NOTE To deselect a selected worksheet without deselecting the group, hold the [Ctrl ] key and click the worksheet tab you want to deselect . When multiple worksheets are selected, the text [Group] appears next to the title of the workbook. To deselect worksheet tabs, click any unselected worksheet tab.



P ROCEDURES

1. Click the tab of the first worksheet you want to select. 2. Hold [Shift] and click the tab of the last adjacent worksheet you want to select. 3. To add non-adjacent worksheets to the group, hold [Ctrl] and click the tab for each worksheet you want to add.

Page 6

OFFICEPRO, Inc.