Excel 2016 Managing Worksheets

Excel 2016

Lesson 1 – Working with Multiple Worksheets



S TEP - BY -S TEP

Select multiple worksheets.

Steps

Practice Data

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

Scroll as necessary and click the January tab

Hold [Shift] and click the March tab

Hold [Ctrl] and click the June tab

Deselect the worksheet tabs by clicking the unselected April tab.

C OLORING W ORKSHEET T ABS  D ISCUSSION

Excel allows you to add color to worksheet tabs. If color has been added to a worksheet tab, the tab color fades while the tab is selected; the entire sheet tab displays the color whenever the tab is not selected.

You can select single or multiple worksheets when adding color to worksheet tabs. For example, you may want to add the color red to all worksheets containing sales figures for the first quarter and add a different color for each of the second quarter worksheets.

OFFICEPRO, Inc.

Page 7