Excel 2016 Managing Worksheets

Lesson 2 – Managing Worksheets

Excel 2016

Steps

Practice Data

5. Select the first cell in the paste range. The cell is selected.

Click cell A2

6. Click the Paste button.

Click

The cut cells appear in the paste range in the destination worksheet.

Practice the Concept : Select the December data in the range A20:I25 on the October worksheet and move it to cell A2 in the December worksheet. On the October worksheet, delete the headings in cells A10 and A19. If necessary, close the Clipboard task pane.

C OPYING D ATA BETWEEN W ORKSHEETS  D ISCUSSION

You can copy data between worksheets, using the same techniques you use to copy data within a worksheet. For example, if one worksheet contains information you want to include on each worksheet in the workbook, you can copy the information as needed.

When copying data between worksheets, formulas update to the new locations, just as they do when you copy information within a worksheet.

NOTE You can also copy data to another worksheet by dragging. Select the data, press the [Ctrl] and [Alt] keys, and drag the selection by its border, first to the worksheet tab, and then when the worksheet appears, to the desired location. When you copy data between worksheets, the Paste Options button may appear, allowing you to control how the data is pasted.



P ROCEDURES

1. Select the worksheet containing the data you want to copy. 2. Select the cells you want to copy. 3. Click the Copy button . 4. Select the destination worksheet. 5. Select the first cell in the paste range.

6. Click the Paste button

.

Page 22

OFFICEPRO, Inc.