Excel 2016 Managing Worksheets

Lesson 2 – Managing Worksheets

Excel 2016

C OPYING W ORKSHEETS  D ISCUSSION

You can copy a worksheet and its contents to a new location. This is useful if you have designed a framework for a worksheet (e.g., monthly column headings, row headings, formatting, and formulas) and you want to use that framework for several similarly structured worksheets.

When you copy a worksheet, the new copy is given the name of the original worksheet followed by a sequential number. You can also copy multiple, grouped worksheets. After the worksheets have been copied, they are automatically ungrouped.

A copied worksheet

NOTE When copying multiple worksheets, you must drag the tab for the first worksheet in the group, which appears in bold type. Otherwise, if you hold the [Ctrl] key and click the tab of another worksheet in the selected group, that worksheet is deselected. If you cannot view the destination location for the copied worksheet, drag the copy beyond the edge of the displayed worksheet tabs. The tabs scroll to display additional worksheets.

Page 16

OFFICEPRO, Inc.