Excel 2016 Managing Worksheets

Lesson 1 – Working with Multiple Worksheets

Excel 2016

Steps

Practice Data

2. To view the next tab to the left, click the Previous Tab button. The next worksheet tab to the left appears. 3. To view the contents of a worksheet, click the desired worksheet tab. The worksheet appears in the worksheet area.

Click

Click the February tab

Practice the Concept: Drag the tab split box, which appears to the right of the last visible tab, to the right until the October tab appears.

S ELECTING W ORKSHEETS  D ISCUSSION

You can select a worksheet at any time by displaying the sheet list. The sheet list contains the name of all the worksheets in a workbook. It is a convenient tool when using a workbook with many worksheets. For example, in an annual workbook containing monthly worksheets, use the sheet list to quickly select and view a Summary sheet at the end of the file.

The sheet list

Page 4

OFFICEPRO, Inc.