Excel 2016 Managing Worksheets

Excel 2016

Lesson 2 – Managing Worksheets



S TEP - BY -S TEP Copy data between worksheets.

Steps

Practice Data

1. Select the worksheet containing the data you want to copy. The worksheet appears. 2. Select the cells you want to copy. The cells are selected.

Scroll as necessary and click the August tab

Select H2: I7

3. Click the Copy button.

Click

A dashed border appears around the selection.

4. Select the destination worksheet. The destination worksheet appears. 5. Select the first cell in the paste range. The cell is selected.

Click the September tab

Click cell H2

6. Click the Paste button.

Click

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

C REATING 3-D F ORMULAS  D ISCUSSION

You can create formulas on one worksheet that refer to numbers on other worksheets in the same or different workbooks. These are known as 3-D formulas. You can use 3-D formulas to summarize data from all the worksheets in a workbook. For example, you can create quarterly worksheets in an annual workbook that summarize data from each month. Like all formulas, 3-D formulas update whenever the data used in the formula changes.

In 3-D formulas, the worksheet names are separated from the cell address by an exclamation point ( ! ). For example, the following formula adds the number in cell E3 in each of four quarterly worksheets:

OFFICEPRO, Inc.

Page 23