Drag the Fill Handle across all the cells in the row you want to fill with the formula. Click the "AutoFill Options" button to select your options for how you want the cells automatically filled.

Now, use the fill handle to apply the same relative formula to cells B4 to B6. To finish this section, copy and paste the formula into cell E3, and use the fill handle again.

Then, you’d use the fill handle to copy that formula to F4:F6. If you define your data range as a table, Excel will automatically copy the formula in F3 to F4:F6 for you.

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.

Microsoft Excel's fill handle tool won't create an alphabetic list by default, but there are a few tricks you can use to make it work.

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, ...

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.