Excel Auto-Fill a Series Without Mouse (Keyboard Only)

Excel Auto-Fill a Series Without Mouse (Keyboard Only)

You're looking for "Fill-Down" or "Fill-Right".

Select the range by moving to the cell to start with... then Shift+↓ or Shift+→ to where you want to fill the contents to... and then press Ctrl+D (to fill-down) or Ctrl+R (to fill-right).

Unfortunately, there is no shortcut key for fill-left or fill-up.

Click Home > Fill, and choose either Down, Right, Up, or Left.

Keyboard shortcut:    press Ctrl+D to fill the formula down in a column, or Ctrl+R to fill the formula to the right in a row.