Working with a Worksheet
Copying from Cell to
The first cell in a block of selected cells might not appear colored or selected. However, if a black border
In Excel you can select multiple cells that are not located in a rectangular block. To select nontouching cells, hold down the Ctrl key as you click each cell that you want to copy. Each cell that you click appears highlighted. Release the Ctrl key when the cells you want to copy are selected.
Either way, click the Copy button or the Cut button on the Standard toolbar after the cells are selected. If you can't see the toolbar, or want to access the command from the menu instead, choose Edit, Copy or Edit, Cut. A marquee appears around the copied cells. If you're cutting the cells, they disappear from the worksheet.
Pasting the cells you copied or cut is a snap. Click the first cell where you want the new cells to appear. If you're pasting a block of cells, you do not have to highlight a rectangular block; Excel assumes that you want the cells to appear in the order and shape in which they were copied. Click the Paste button on the Standard toolbar or chose Edit, Paste. The cells appear in their new location.
Excel pastes data in four ways:
One cell to one cell A single cell from the Clipboard is pasted to one cell.
Multiple cells to one cell Multiple cells are pasted into a rectangular block of which only the first cell is selected.
One cell to multiple cells A single cell from the Clipboard is pasted into a highlighted range of cells.
Multiple cells to multiple cells
The selection of cells from the Clipboard is pasted into a like-
If you've copied other data to the Clipboard from Excel or other programs during the current Windows session, the Clipboard toolbar appears.
As you know from earlier chapters on other Office programs, the Office Clipboard toolbar, as shown in Figure 43.12, holds up to 12 of your copied selections. Office XP and later feature the Clipboard Task Pane that holds up to 24 items. The Clipboard toolbar appears and floats across your worksheet whenever you copy or cut more than one selection during your current Windows session.
The Clipboard toolbar provides some wonderful advantages. Instead of having to paste the last data that you copied, you can pick and choose from previously copied data. However, the Clipboard toolbar stores only the last 12 items that you copied or cut doing the current Windows session. When you close Windows, the Clipboard is automatically cleared.
The drag-and-drop technique is a fast, easy way to copy or move data in the visible viewing area. First, select the cells you want to move or copy. When the cells appear highlighted, move the mouse pointer over the border of the selected cells. The mouse pointer takes the shape of an arrow.
If you want to copy the selected cells, press and hold the Ctrl key. (If you're moving the cells, you don't need to hold down any key.) Now click the mouse button and drag the border. As they're being dragged, an outline of the selected cells appears. When the data is located in the spot in which you want it to appear, release the mouse button. The data appears in the new location as shown in Figure 43.13. You'll see how to copy worksheet entries using the various copy techniques by following these steps:
Select cell B4 by clicking it. A border appears around the cell.
Hold down the Ctrl key and position the mouse pointer in the border of the cell. A small cross appears.
Using the Ctrl key, move the mouse pointer to the cell directly to the right (cell C4). You've just used the drag-and-drop method to copy from one cell to another.
With cell C4 selected, press Ctrl+C. This copies the data in cell C4 to the Clipboard.
Click cells D4 and E4. Both cells are highlighted, which
Press Ctrl+V. This pastes the data into the selected cells. You've just used the shortcut keys to copy and paste data from one cell to other cells.
Click cell B5 to select it. Point to the small square in the lower-right corner of that cell. Notice the mouse pointer changes to a cross, which is called the fill handle.
Drag the fill handle to cells C5, D5, and E5. Now you've used the fill handle method to copy data when cells are adjacent to one another.
Select cell B6 (January's Utilities amount) by clicking it and then click the Copy button on the Standard toolbar. A
Click into cell C6 and select cells D6 and E6 by dragging the mouse. The three cells appear highlighted.
Click the Paste button on the Standard toolbar. The amount you copied to the Clipboard is copied to the cells you selected.