Excel 2013 has a tool called the fill handle, however, which can make it much simpler to fill a series of cells with numbers. Step 5: Check the box to the left of Enable fill handle and cell drag-and-drop. You can also select whether or not you would like Excel to alert you if you are about to overwrite a cell. 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.

Excel for Office 365 Excel 2019 Excel 2016 Excel 2013 Excel 2010 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, 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: • Click File > Options. • In the Advanced category, under Editing options, select or clear the Enable fill handle and cell drag-and-drop check box.

In this video tutorial, viewers learn how to disable the quick fill handle and drag and drop option in Microsoft Excel. Best video software for mac 2015. This task is very easy, simple and fast to do. Begin by clicking on the Office button and click on Excel Options at the bottom.

Then click on the Advanced tab and deselect 'Enable fill handle and cell drag and drop' option under Editing Options. Finish by clicking on OK. This video will benefit those viewers who use Microsoft Excel for their work, and would like to learn how to disable the quick fill handle and drag-drop feature because they input different information each time.