Enable fill handle and cell drag-and-drop in Excel

This post explains in simple steps on how to enable or disable the fill handle and drag-and-drop option in Microsoft Excel.

How to Enable fill handle and cell drag-and-drop in Excel ?

Microsoft Excel provides an option to display or hide the fill handle feature. The fill handle and drag-and-drop option is turned on by default in Excel.

By using this feature you can select a series of cells and drag the cell corner to complete the series over a column or row. You can do this by selecting a range of cells and positioning the mouse pointer on a cell border and drag the fill handle to complete the series.

To turn on this Fill handle and drag-and drop option do the following:

  • Click File -> Options.
  • Select Advanced, under Editing options, select the Enable fill handle and cell drag-and-drop checkbox.
Enable fill handle and cell drag-and-drop in Excel
  • Before Fill handle and drag-and-drop option:
Enable fill handle and cell drag-and-drop in Excel
  • After Fill handle and drag-and-drop option:
Enable fill handle and cell drag-and-drop in Excel

Leave A Reply

Your email address will not be published. Required fields are marked *

You May Also Like

In this article, you will learn about the SKEW.P function, the formula syntax and usage of the function in Microsoft...
In this article, you will learn about the SKEW function, the formula syntax and usage of the function in Microsoft...
In this article, you will learn about the RANK.EQ function, the formula syntax and usage of the function in Microsoft...
  • Excel
  • November 23, 2021