Excel 2016 Managing Worksheets

Excel 2016

Lesson 1 – Working with Multiple Worksheets

N AVIGATING BETWEEN W ORKSHEETS  D ISCUSSION

The active worksheet is the worksheet that is currently displayed. You can display a worksheet by clicking its tab. By default, only nine worksheet tabs appear in the workbook window. If you have more than nine worksheets, you cannot see all the worksheet tabs at one time. For example, in a workbook that contains worksheets for every month of the year, the tabs for the last few months of the year would be hidden, depending on how the months are named. If the worksheet tab you want to view is not visible, you can use the tab scrolling buttons to display hidden tabs.

Button Function

Displays the next worksheet tab to the right.

Displays the previous worksheet tab to the left.

NOTE You can drag the tab split box located to the left of the horizontal scroll bar as desired to display more or fewer tabs. You can double-click the tab split box to return the tab display to the default number of tabs.



P ROCEDURES

1. To view the next tab to the right, click the Next Tab button . 2. To view the next tab to the left, click the Previous Tab button . 3. To view the contents of a worksheet, click the desired worksheet tab.



S TEP - BY -S TEP From the Student Data directory, open MONTH1.XLSX . Navigate between worksheets.

Steps

Practice Data

1. To view the next tab to the right, click the Next Tab button. The next worksheet tab to the right appears.

Click

OFFICEPRO, Inc.

Page 3