Excel 2016 Managing Worksheets

Excel 2016

Lesson 2 – Managing Worksheets

Adding data to grouped worksheets



P ROCEDURES

1. Select the first worksheet you want to group. 2. Hold [Ctrl] and click the tab of each additional worksheet you want to add to the group. 3. Select the cell in which you want to enter data. 4. Type the desired data. 5. Press [Enter] . 6. Select the cell to which you want to apply formatting. 7. Apply the desired formatting.



S TEP - BY -S TEP Work with grouped worksheets.

If necessary, display the Home tab.

Scroll as necessary to display the Qtr 1 and Qtr 2 tabs.

OFFICEPRO, Inc.

Page 19