Excel 2016 Managing Worksheets

Excel 2016

Lesson 2 – Managing Worksheets



P ROCEDURES

1. Select the tab of each worksheet you want to copy. 2. Hold [Ctrl] and drag the selected worksheet tabs to the desired location.



S TEP - BY -S TEP From the Student Data directory, open MONTH2.XLSX . Copy a worksheet.

Scroll to view the December tab.

Steps

Practice Data

1. Select the tab of each worksheet you want to copy. The worksheet tab(s) are selected. 2. Hold [Ctrl] and drag the selected worksheet tabs to the desired location.

Click the Qtr 3 tab

Hold [Ctrl] and drag the Qtr 3 tab to the right of the December tab

A copy of the worksheet(s) appears in the new location.

Rename the copied worksheet Qtr 4 .

M OVING W ORKSHEETS  D ISCUSSION

You can move a worksheet to a new location in a workbook and still have it retain the same name and contents. Moving worksheets allows you to rearrange them or to place new worksheets in a desired location in the workbook. For example, in an annual workbook containing monthly worksheets, you may want to reorder the worksheets so that the first, second, and third months in each quarter are adjacent.

You can also move multiple, grouped worksheets. After multiple grouped worksheets have been moved, they are automatically ungrouped.

OFFICEPRO, Inc.

Page 17