Excel.Tips.Net Welcome toExcel.Tips.Net

Helpful Links

Tips.Net Home
ExcelTips Home
Ask an Excel Question
Make a Comment

Tips.Net Store

ExcelTips FAQ
ExcelTips Premium

Learn Access Now
Free Printable Forms

Beauty Tips
Car Tips
Cleaning Tips
College Tips
Cooking Tips
Excel2007 Tips
ExcelTips
Family Tips
Gardening Tips
Health Tips
Home Tips
Legal Tips
Money Tips
Organizing Tips
Pest Tips
Pet Tips
Wedding Tips
Word2007 Tips
WordTips

Advertise on the
ExcelTips Site

Newest Tips

Removing Borders

Converting to Octal

Filtering Columns for Unique Values

Printing Multiple Worksheets on a Single Page

Changing the Default Font

Creating a Drawing Object

Determining a Value of a Cell

 

Moving and Copying Cells

Summary: At the very heart of editing is the ability to move and copy cells in a worksheet. Understanding the differences between these operations, as well as how to perform them, is important for any Excel user. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, Excel 2003, and Excel 2007.)

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.

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2115) applies to Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Remove Some Stress at Tax Time! Doing your personal income taxes can be a royal pain. Why not make the process just a bit less stressful with our 101-question checklist. You can prepare for filing your taxes with confidence, knowing you've covered all your bases.
 
Check out Filing Your Income Taxes Checklist today!