Excel 2016 Managing Worksheets

Excel 2016

Lesson 1 – Working with Multiple Worksheets

Steps

Practice Data

1. Select the first worksheet you want to print. The worksheet is selected. 2. Hold [Shift] and click the tab of the last adjacent worksheet you want to print. The worksheets are selected.

Scroll as necessary and click the January tab

Hold [Shift] and click the March tab

3. Select the File tab.

Click

The File page ( Backstage view) appears.

4. Select the Print button.

Click Print

The Print dialog box opens.

5. Select the Print Active Sheets option, if necessary. The Active sheets option is selected.

Click Print Active Sheets , if necessary

6. Select OK .

Click

The Print dialog box closes, and Excel prints the selected worksheets.

Practice the Concept: Select the April , May , and June worksheets and use the Print Preview button to view the printouts. Then, close print preview and click the April tab to deselect the group. Close MONTH1.XLSX.

OFFICEPRO, Inc.

Page 13