Thursday, January 17, 2019

Fix: Excel Fill Handle is missing

How to enable Fill handle in Excel?

The Fill Handle feature in Excel allows you to select a series of cells with incremental values and drag the cell corner to complete the series. However, if this does not work then check out the following :
  1. Click "File"
  2. Click "Options"
  3. Click "Advanced"
  4. Next, tick the option "Enable fill handle and cell drag-and-drop"
  5. Next, save the settings and then retry to fill the series by dragging the cell corner.

No comments: