How to Turn on Change Tracking in Excel 2013 Workbooks
How to Protect a Document in Excel 2013
How to Enable Excel Cell Range Editing by Certain Users

How to Copy With Drag and Drop in Excel 2013

What if you want to copy a cell range in Excel 2013? Suppose that you need to start a new table in rows farther down the worksheet, and you want to copy the cell range with the formatted title and column headings for the new table. To copy the formatted title range in the sample worksheet, follow these steps:

  1. Select the cell range.

  2. Hold the Ctrl key down while you position the mouse pointer on an edge of the selection (that is, the expanded cell cursor).

    The pointer changes from a thick, shaded cross to an arrowhead with a + (plus sign) to the right of it with the drag-and-drop ScreenTip beside it. The plus sign next to the pointer is your signal that drag and drop will copy the selection rather than move it.

  3. Drag the cell-selection outline to the place where you want the copy to appear and release the mouse button.

If, when using drag and drop to move or copy cells, you position the outline of the selection so that it overlaps any part of cells that already contain entries, Excel displays an alert box that asks whether you want to replace the contents of the destination cells.

To avoid replacing existing entries and to abort the entire drag-and-drop mission, click the Cancel button in this alert box. To go ahead and exterminate the little darlings, click OK or press Enter.

blog comments powered by Disqus
Transfer Sheets from One Excel 2013 Workbook to Another
How to Assign Graphic Images as Excel Worksheet Backgrounds
How to Add a Digital Signature to Excel 2013 Workbooks
How to Cut and Paste in Excel 2013
Share Excel 2013 Workbooks Saved on Your SkyDrive