bottom
Great ExcelTips!
         
Your e-mail address is safe!
Close Note

Tips.Net > ExcelTips Home > Data Entry > Moving Data > Moving Cells Using the Mouse

Moving Cells Using the Mouse

Summary: Moving cells in an Excel worksheet without using cut and paste. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, and Excel 2003.)

As you edit your worksheet, you can use the mouse to move cells from one location to another. You do this by following these steps:

  1. Select the range of cells you want to move by highlighting the range with the mouse.
  2. Position the mouse pointer over the heavy border that surrounds the selected range. The pointer should turn into an arrow.
  3. Click and drag the range to a new location. As you move the mouse, the outline of the range moves.
  4. When you are satisfied with the new location, release the mouse pointer. The cells are moved.

If there is anything already at the target location, Excel may ask you if you want to overwrite the existing cells. You can respond according to your desires.

If you cannot seem to edit this way, or if no heavy border (step 2) appears around your selected range, then drag-and-drop editing is probably turned off on your system. To check this, follow these steps:

  1. Choose Options from the Tools menu. This displays the Options dialog box.
  2. Click on the Edit tab. (Click here to see a related figure.)
  3. Make sure the Allow Cell Drag and Drop check box is selected.
  4. If you want to be warned before overwriting information during an edit, make sure the Alert Before Overwriting Cells check box is selected.
  5. Click on OK.

Tip #2648 applies to Microsoft Excel versions: 97 | 2000 | 2002 | 2003


Step Up and Take Control! Subscribers to ExcelTips know just how valuable a resource it is. ExcelTips Premium provides twice the number of exceptional, easy-to-understand tips every week in an ad-free newsletter, as well as substantial discounts on ExcelTips archives and e-books.
 
Check out ExcelTips Premium today!

Helpful Links

Ask an Excel Question
Make a Comment

Tips.Net Home

ExcelTips FAQ
ExcelTips Premium

Learn Access Now

Beauty Tips
Bugs and Pests Tips
Car Tips
Cleaning Tips
College Tips
Cooking Tips
Excel2007 Tips
ExcelTips
Family Tips
Gardening Tips
Health Tips
Home Tips
Money Tips
Organizing Tips
Pet Tips
Word2007 Tips
WordTips

Advertise on the
ExcelTips Site

 

Great Info!

Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your e-mail address and click "Subscribe."
     
(Your e-mail address will never be shared with anyone, ever.)