Will be inserted as a new row in the existing table of data.

When the I-beam pointer runs horizontally between rows, you know that the selection.

You drop it by displaying an I-beam-type indicator in front of the mouse pointer: Excel indicates where the selected data will be inserted at the time To do this kind of insert moving or copying, you must hold down the Shift key as you drag theĬell selection to its new position. Of cells to a new (blank) place in the worksheet but also want to insert the cells into an existing table You the chance to abort the procedure even after you release the mouse button.ĭrag-and-drop spreadsheet editing is most effective when you not only need to move or copy a range When you hold down the Ctrl key to copy (rather than move) the cell selection with dragand-ĭrop, Excel doesn't display the Replace Contents alert box - the one that still gives Things back to right by using the Undo feature (Ctrl+Z). Moving or copying (see the warning on copying with drag-and-drop that follows), you can always puts Of course, if you do mess up and end up replacing entries with the data you're At least when the Alertīefore Overwriting Cells option is enabled, you get a warning that you're about to mess up and replaceĭata that you might need.

Otherwise, you can too easily obliterate parts of your spreadsheetīy replacing data you don't want disturbed with the data you're moving. On the Edit tab of the Options dialog box.

Overwriting Cells option - which appears immediately beneath the Allow Cell Drag and Drop option Drag-and-drop editing in the worksheet is great as long as you never disable the Alert before

Excel drag and drop cells