MARISSA JONES ONLY!!!!

Copy and Move Cell Entries

Learning Outcomes

· Copy a range to the Clipboard

· Paste a Clipboard entry

· Empty cell contents

· Copy cell contents

There are three ways you can copy or move cells and ranges (or the contents within them) from one location to another: the Cut, Copy, and Paste buttons on the Home tab on the Ribbon; the fill handle in the lower-right corner of the active cell or range; or the drag-and-drop feature. When you copy cells, the original data remains in the original location; when you cut or move cells, the original data is deleted from its original location. You can also cut, copy, and paste cells or ranges from one worksheet to another.  In addition to the 20% rise in tour expenses, you also want to show a 30% rise. Rather than retype this information, you copy and move selected cells.

Steps

Quick Tip

To cut or copy selected cell contents, activate the cell, then select the characters within the cell that you want to cut or copy.

1. 1

Select the range B3:E3, then click the Copy button  in the Clipboard group on the Home tab

The selected range (B3:E3) is copied to the  Clipboard , a temporary Windows storage area that holds the selections you copy or cut. A moving border surrounds the selected range until you press [Esc] or copy an additional item to the Clipboard.

2. 2

Click the launcher  in the Clipboard group

The Office Clipboard opens in the Clipboard task pane, as shown in  Figure 2-9 . When you copy or cut an item, it is cut or copied both to the Clipboard provided by Windows and to the Office Clipboard. Unlike the Windows Clipboard, which holds just one item at a time, the Office Clipboard contains up to 24 of the most recently cut or copied items from any Office program. Your Clipboard task pane may contain more items than shown in the figure.

Figure 2-9Copied Data in Office Clipboard

Quick Tip

Once the Office Clipboard contains 24 items, the oldest existing item is automatically deleted each time you add an item.

3. 3

Click cell B19, then click the Paste button in the Clipboard group

A copy of the contents of range B3:E3 is pasted into the range B19:E19. When pasting an item from the Office Clipboard or Clipboard into a worksheet, you only need to specify the upper left cell of the range where you want to paste the selection. Notice that the information you copied remains in the original range B3:E3; if you had cut instead of copied, the information would have been deleted from its original location once it was pasted.

4. 4

Press [Delete]

The selected cells are empty. You have decided to paste the cells in a different row. You can repeatedly paste an item from the Office Clipboard as many times as you like, as long as the item remains in the Office Clipboard.

Quick Tip

You can also close the Office Clipboard pane by clicking the launcher in the Clipboard group.

5. 5

Click cell B20, click the first item in the Office Clipboard, then click the Close button  on the Clipboard task pane

Cells B20:E20 contain the copied labels.

6. 6

Click cell A14, press and hold [Ctrl], point to any edge of the cell until the pointer changes to , drag cell A14 to cell A21, release the mouse button, then release [Ctrl]

The copy pointer  continues to appear as you drag, as shown in  Figure 2-10 . When you release the mouse button, the contents of cell A14 are copied to cell A21.

Figure 2-10Copying Cell Contents with Drag-and-Drop

7. 7

Click to the right of 2 in the formula bar, press [Backspace], type 3, then click the Enter button 

8. 8

Click cell B21, type =, click cell B12, type *1.3, click  on the formula bar, then save your work

This new formula calculates a 30% increase of the expenses for Quarter 1, though using a different method from what you previously used. Anything you multiply by 1.3 returns an amount that is 130% of the original amount, or a 30% increase. Compare your screen to  Figure 2-11 .

Figure 2-11Formula Entered to Calculate a 30% Increase

Inserting and Deleting Selected Cells

As you add formulas to your workbook, you may need to insert or delete cells. When you do this, Excel automatically adjusts cell references to reflect their new locations. To insert cells, click the Insert list arrow in the Cells group on the Home tab, then click Insert Cells. The Insert dialog box opens, asking if you want to insert a cell and move the current active cell down or to the right of the new one. To delete one or more selected cells, click the Delete list arrow in the Cells group, click Delete Cells, and in the Delete dialog box, indicate which way you want to move the adjacent cells. When using this option, be careful not to disturb row or column alignment that may be necessary to maintain the accuracy of cell references in the worksheet. Click the Insert button or Delete button in the Cells group to insert or delete a single cell.