1. Drag the Fill Handle of a single cell to copy that cell. The Fill Handle is at the bottom right of any selected cell or group of cells. 2. Drag the Fill Handle of a cell containing January, Jan, ...

Instead, select the cell containing the formula, and double-click the fill handle rather than dragging it. In an instant, Excel duplicates the formula down the column until it reaches a blank row.

Click on the formula bar and close the bracket. Hit Enter. When you are done, use the Fill Handle to copy the formula to all the cells.

If Excel is not highlighting cells in the formula, enable 'Allow editing directly in cells' and 'Enable fill handle and cell drag-and-drop' in Excel options.

By using the Fill Handle Options, you can maintain consistency in your spreadsheet’s appearance while efficiently applying formulas and generating data series. Secret Excel Tools almost nobody uses ...