Excel 2016 Managing Worksheets

Excel 2016

Lesson 1 – Working with Multiple Worksheets

Steps

Practice Data

2. Select the Home tab.

Click Home

The Home tab is displayed.

3. Select the Format button. The Format menu opens.

Click

4. Select the Tab Color command. The Theme Colors gallery is displayed.

Point to Tab Color

5. Select the desired color.

Click Red (second column, Standard Colors)

The color is selected and a colored horizontal line appears below the worksheet name.

Practice the Concept: Hold [Ctrl] ; click the April , May , and June tabs and add the color green to all the tabs at the same time. Then, add the color red to the February and March tabs. Select the January tab to deselect the group.

I NSERTING W ORKSHEETS  D ISCUSSION

You can insert new worksheets into a workbook. For example, in a workbook containing worksheets for each month of the year, you can add worksheets for each quarter of the year. New worksheets are inserted to the left of the active worksheet. Excel gives new worksheets a default worksheet name, which you can change.

NOTE You can also insert worksheets with the Insert Worksheet icon on the right of the last sheet in the workbook. This will insert a new sheet after the last sheet in the workbook. If you select multiple, adjacent worksheets, multiple worksheets are inserted. You cannot insert non-adjacent worksheets.



P ROCEDURES

1. Select the worksheet to the left of which you want to insert a new worksheet. 2. Select the Home tab.

OFFICEPRO, Inc.

Page 9