Excel 2016 Managing Worksheets

Lesson 2 – Managing Worksheets

Excel 2016

Steps

Practice Data

1. Select the first worksheet you want to group. The worksheet is selected. 2. Hold [Ctrl] and click the tab of each additional worksheet you want to add to the group. The worksheets are selected. 3. Select the cell in which you want to enter data. The cell is selected. The data is entered into the corresponding cell in each of the selected worksheets. 6. Select the cell to which you want to apply formatting. The cell is selected. 7. Apply the desired formatting. The formatted is applied to the corresponding cell in each of the selected worksheets. 4. Type the desired data. The data appears in both the cell and formula bar. 5. Press [Enter] .

Click the Qtr 1 tab

Hold [Ctrl] and click the Qtr 2 tab

Click cell A1

Type WSG Quarterly Report

Press [Enter]

Click cell A1

Click

Click the June tab to deselect the worksheets. View the Qtr 1 and the Qtr 2 worksheets to verify the changes.

Practice the Concept : Replace the text in cell A1 in the Qtr 3 and Qtr 4 worksheets with the underlined text WSG Quarterly Report . Ungroup the worksheets.

M OVING D ATA BETWEEN W ORKSHEETS  D ISCUSSION If a worksheet contains data that can be better utilized on another worksheet, you can move data from one worksheet to the other.

Page 20

OFFICEPRO, Inc.