Excel 2016 Managing Worksheets

Excel 2016

Lesson 2 – Managing Worksheets

The most common reason for moving data is to break up a single large worksheet into several smaller ones. For example, if a workbook consists of one large worksheet containing data for each month of the year, you can move the monthly data to separate worksheets.

NOTE You can also move data to another worksheet by dragging. Select the data, press the [Alt] key, and drag the selection by its border, first to the worksheet tab, and then when the worksheet appears, to the desired location. When you move 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 move. 2. Select the cells you want to move. 3. Click the Cut button . 4. Select the destination worksheet. 5. Select the first cell in the paste range.

6. Click the Paste button

.



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

If necessary, display the Home tab.

Steps

Practice Data

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

Click the October tab

Select A11:I16

3. Click the Cut button.

Click

A dashed border appears around the selected cells.

4. Select the destination worksheet. The destination worksheet appears.

Click the November tab

OFFICEPRO, Inc.

Page 21