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:
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:
Figure 1. The Advanced option of the Excel Options dialog box.
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (12351) applies to Microsoft Excel 2007, 2010, 2013, and 2016. You can find a version of this tip for the older menu interface of Excel here: Moving Cells Using the Mouse.
Professional Development Guidance! Four world-class developers offer start-to-finish guidance for building powerful, robust, and secure applications with Excel. The authors show how to consistently make the right design decisions and make the most of Excel's powerful features. Check out Professional Excel Development today!
Excel makes it easy to copy and paste a range of cells. Easy, that is, unless the range isn't contiguous. If you have a ...
Discover MoreIf you hide the first rows of a worksheet, you may have a hard time getting those rows visible again. Here's a simple way ...
Discover MoreDo you want to limit what can be entered into a particular cell in your worksheet? Here are three separate ways you can ...
Discover MoreFREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
2021-02-15 04:20:53
Willy Vanhaelen
In point 2 "The pointer should turn into an arrow.", should be "The pointer should turn into a CROSS arrow (move pointer)." (see fig 1).
You can also use this technique to COPY cells by holding down the Ctrl key. The pointer should turn into the copy pointer (see fig 2).
(see Figure 1 below)
(see Figure 2 below)
Figure 1. move pointer
Figure 2. copy pointer
2016-03-12 20:34:21
Bob D
This is fine for raw data that is not managed elsewhere in the application by way of data dependency or formulae interrogation. Indeed it can be dangerous to the point of totally destroying the integrity of data analysis. Best disabled.
Got a version of Excel that uses the ribbon interface (Excel 2007 or later)? This site is for you! If you use an earlier version of Excel, visit our ExcelTips site focusing on the menu interface.
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Copyright © 2021 Sharon Parq Associates, Inc.
Comments