FG
💻 Software

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

Fresh7 days ago
Mar 15, 2026613758 views
Confidence Score1%
1%

Problem

When I want to extend a series or something along those lines, I can highlight a group of cells, then click on the bottom right corner of the highlighting box and drag down. Excel will then attempt to automatically extend the contents as well as it can. Is there a keyboard function that will allow me to do this? I like to use the keyboard to avoid repetitive mouse motions. I can use the shift key and arrow keys to make a selection, but I don't know what (if any) key can trigger this function. I also don't really know what this function is actually called.

Unverified for your environment

Select your OS to check compatibility.

1 Fix

Canonical Fix
Unverified Fix
New Fix – Awaiting Verification

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

Low Risk

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.

Awaiting Verification

Be the first to verify this fix

Sign in to verify this fix

Environment