21 October 2015

Excel auto-fill keyboard "shortcut"

Excel's AutoFill is usually activated by selecting a group of cells and dragging the fill handle (the black square on the bottom-right hand corner of a selection) with the mouse until you have the range you want. The keyboard "shortcut" (more a sequence of keystrokes than a simple shortcut) is to select the range you want first then type: Alt+h,fi,s,Alt+f,Return. The breakdown of the steps are:

  1. Select the range you want.
  2. Alt+h: show the Home menu strip.
  3. fi: show the Fill sub-menu.
  4. s: show the Series dialog.
  5. Alt+f: In the Series dialog, select Type=AutoFill.
  6. Return: In the Series dialog, press the OK button.