Moving Cell Contents

Moving Cell Contents

graphics/microsoft07.gif

Unlike copied data, moved data no longer remains in its original location. Perhaps you typed data in a range of cells near the top of a worksheet, but later realized it should appear near the bottom of the sheet. Moving data lets you change its location without having to retype it. When you move data, you are cutting the data from its current location and pasting it elsewhere. Cutting removes the selected cell or range content from the worksheet and places it on the Windows Clipboard.

Move Data Using the Clipboard

graphics/one_icon.jpg

Select the cell or range that contains the data you want to move.

graphics/tow_icon.jpg Click the Cut button on the Standard toolbar.

An outline of the selected cells, called a marquee, shows the size of the selection. If you don't want to paste this selection, press Esc to remove the marquee.

graphics/three_icon.jpg

Click the top-left cell of the range where you want to paste the data.

graphics/foure_icon.jpg Click the Paste button on the Standard toolbar.

The marquee disappears. The data is still on the Clipboard and still available for further pasting until you replace it with another selection.

graphics/02inf24.jpg

graphics/02inf25.jpg

Did You Know?

You can use the Office Clipboard to cut multiple items . When the Clipboard toolbar is displayed, selections you cut can be placed on this clipboard. You can move data to the Clipboard, and then paste it at a later time.

Move Data Using Drag-and-Drop

graphics/one_icon.jpg

Select the cell or range that contains the data you want to move.

graphics/tow_icon.jpg

Move the mouse pointer to an edge of the cell until the pointer changes to an arrowhead .

graphics/three_icon.jpg

Press and hold the mouse button while dragging the selection to its new location, and then release the mouse button.

graphics/02inf26.jpg

Did You Know?

You can reposition the mouse pointer to use drag-and-drop . If the mouse pointer changes to a thick plus sign, reposition the pointer on the edge of the selected range until the pointer changes to an arrowhead.

Paste Cells from Rows to Columns or Columns to Rows

graphics/one_icon.jpg

Select the cells that you want to switch.

graphics/tow_icon.jpg

Click the Copy button on the Standard toolbar.

graphics/three_icon.jpg

Click the top-left cell of where you want to paste the data.

graphics/foure_icon.jpg

Click the Edit menu, and then click Paste Special.

graphics/five_icon.jpg

Click to select the Transpose check box.

graphics/six_icon.jpg

Click OK.

graphics/02inf27.jpg



Show Me Microsoft Office Excel 2003
Show Me Microsoft Office Excel 2003
ISBN: 0789730057
EAN: 2147483647
Year: 2002
Pages: 291

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net