Moving and Copying Cells

Moving and copying cells is a very common procedure when you are developing or editing your worksheets. Excel refers to moving by a different term, however. It is called cutting, which implies that you cut the information from one place and put it in another. Copying differs from cutting in that copying does not disturb the original cells; cutting clears them.

Whether you are cutting or copying, these operations involve the use of the Clipboard, a temporary storage area that is built into Windows. To cut or copy information, you must first select the cells you want to affect. Then do one of the following:

• To cut cells, just press Ctrl+X; this shortcut will work in all versions of Excel. If you don't want to use the shortcut, then you could right-click the selection and choose Cut from the Context menu. If you are using Excel 2007 you can display the Home tab of the ribbon and click Cut in the Clipboard group. In older versions of Excel you can choose Cut from the Edit menu or click on the Cut tool on the toolbar.
To copy the cells, just press Ctrl+C or Ctrl+Insert.; these shortcuts should work in all versions of Excel. You can also right-click the selection and choose Copy from the Context menu. In Excel 2007 you can also display the Home tab of the ribbon and click Copy in the Clipboard group. In older versions of Excel you can choose Copy from the Edit menu or click on the Copy tool on the toolbar.

Once you have done one of these, you can use the Paste or Paste Special commands to place your information elsewhere. Pasting functions the same as in other Windows programs; it places the contents of the Clipboard at the current cursor location. In the case of Excel, the information is placed in your worksheet beginning with the currently selected cell. You can paste the Clipboard contents by choosing Paste from the Edit menu, pressing Ctrl+V, right-clicking a cell and choosing Paste from the Context menu, clicking the Paste tool on the Home tab of the ribbon (Excel 2007), choosing Paste from the Edit menu (older versions of Excel), or clicking the Paste tool on the toolbar (older versions of Excel).

Within Excel there is another pasting option available. This option, called Paste Special, is rather unique. It allows you to specify how Excel should paste the information in the Clipboard. When you choose it, you will see the Paste Special dialog box. (Click here to see a related figure.) The settings in the dialog box control which portion of the information in the Clipboard you want pasted, as well as what operations you want taken on the information being pasted.

To display the dialog box in Excel 2007, display the Home tab of the ribbon, click the down-arrow under the Paste tool, then choose Paste Special. In older versions of Excel choose Paste Special from the Edit menu.