Excel 2016 Managing Worksheets

Lesson 2 – Managing Worksheets

Excel 2016



P ROCEDURES

1. Select the tab of each worksheet you want to move. 2. Drag the selected worksheet tabs to the desired location.



S TEP - BY -S TEP

Move a worksheet.

Display the Annual worksheet tab.

Steps

Practice Data

1. Select the tab of each worksheet you want to move. The worksheet tab(s) are selected. 2. Drag the selected worksheet tabs to the desired location. The worksheet tab(s) appear in the new location.

Click the Annual tab

Drag the Annual tab to the right of the Qtr 4 tab

U SING G ROUPED W ORKSHEETS  D ISCUSSION

When multiple worksheets are selected, the worksheets are grouped. If you type, edit, create formulas, or format entries in one of the grouped worksheets, entries in the same cell in all the grouped worksheets change.

Grouping is useful when you want to create the same structure and appearance in all the worksheets in a workbook. For example, when creating monthly worksheets in a workbook, you can group the worksheets so that you can enter and format all the column headings, row headings, and formulas in the group at one time.

Page 18

OFFICEPRO, Inc.