Page 226 - Excel 2013 All-in-One For Dummies

208 Copying and Moving Stuff Around
Carried away with cut-and-paste
Given the convenience of using drag-and-drop, you may still prefer to use the more traditional cut-and-paste method when moving or copying cells in a worksheet. This is especially true when running Excel 2013 on a touch- screen device that doesn’t have access to a mouse. Cut-and-paste uses the Clipboard (a special area of memory shared by all Windows programs), which provides a temporary storage area for the data in your cell selection until you paste the selection into its new position in the worksheet.
To move a cell selection, click the Cut command button (the one with the scissors icon) in the Clipboard group at the beginning of the Ribbon’s Home tab (or press the shortcuts, Alt+HX, Ctrl+X, or Shift+Delete). To copy the selection, click the Copy command button (with the two sheets of paper side by side immediately beneath the Cut button) on the Home tab (or press the shortcuts, Alt+HC, Ctrl+C, or Ctrl+Insert).
When you cut or copy a selection to the Clipboard, Excel displays a marquee around the cell selection (sometimes called marching ants), and the follow- ing message appears on the status bar:
Select destination and press ENTER or choose Paste
To complete the move or copy operation, simply select the first cell in the range where you want the relocated or copied selection to appear and then press the Enter key, click the Paste button on the Home tab, or press the shortcuts Alt+HV, Ctrl+V, or Shift+Insert. Excel then completes the move or copy operation, pasting the range as required, starting with the active cell. When selecting the first cell of a paste range, be sure that you have sufficient blank cells below and to the right of the active cell so that the range you’re pasting doesn’t overlay any existing data that you don’t want Excel to replace.
Unlike when moving and copying a cell selection with drag-and-drop, the cut-and-paste method doesn’t warn you when it’s about to replace existing cell entries in cells that are overlaid by the incoming cell range — it just goes ahead and replaces them with nary a beep or an alert! If you find that you moved the selection to the wrong area or replaced cells in error, imme- diately click the Undo button on the Quick Access toolbar or press Ctrl+Z to restore the range to its previous position in the worksheet.
“Paste it again, Sam”
When you complete a copy operation with cut-and-paste by clicking the Paste button in the Clipboard group at the beginning of the Ribbon’s Home