Sign in with Microsoft
Sign in or create an account.
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

By default, the fill handle and drag-and-drop editing is turned on in Excel so that you can drag the mouse to move and copy cells by doing the following:

  • Move a cell or range of cells by positioning the mouse pointer on a cell or cell range border so that it changes to a move pointer , and then dragging the cell to another location.

  • Copy a cell or range of cells by holding down CTRL while you position the mouse pointer on a cell or cell range border so that it changes to a copy pointer Excel Copy Pointer, and then dragging the cell or range of cells to another location.

  • Drag the fill handle to copy data or to fill adjacent cells with a series of data.

You can turn this option on or off as needed by doing the following:

  1. Click File > Options.

  2. In the Advanced category, under Editing options, select or clear the Enable fill handle and cell drag-and-drop check box.

    Note: To help prevent replacing existing data when you drag the fill handle, make sure that the Alert before overwriting cells check box is selected. If you do not want Excel to display a message about overwriting non-blank cells, you can clear this check box.

Need more help?

You can always ask an expert in the Excel Tech Community or get support in Communities.

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!