Excel Auto-Fill a Series Without Mouse (Keyboard Only)
--
Music by Eric Matyas
https://www.soundimage.org
Track title: Thinking It Over
--
Chapters
00:00 Question
00:53 Accepted answer (Score 45)
01:16 Answer 2 (Score 64)
01:47 Answer 3 (Score 11)
02:16 Answer 4 (Score 5)
03:29 Thank you
--
Full question
https://superuser.com/questions/270018/e...
--
Content licensed under CC BY-SA
https://meta.stackexchange.com/help/lice...
--
Tags
#microsoftexcel #microsoftexcel2007
#avk47
ANSWER 1
Score 64
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.
ACCEPTED ANSWER
Score 49
You can use keyboard short cuts to get to anything that's on the Ribbon. Press Alt and then you can see the keystrokes next to each section. To bring up the Fill Series dialog box press Alt and then H F I S.
ANSWER 3
Score 12
Use Shift + ↓ to highlight where you want the series to go - must include the filled in cell that you want to key off of.
Alt + H F I S
Shift + Tab F
Enter
(Inspired by the answers above and some trial and error)
ANSWER 4
Score 5
You can also accomplish this with a macro.
- Go to View tab -> Macro -> "Record Macro"
- Choose an optional name, for example Myautofill (no space in name!)
- Choose an optional shortcut, for example Ctrl+H
- Click OK to start recording the macro
- Go to Home tab -> Editing -> Fill -> Series
- For "Series in" choose "Columns", check the "Trend" option, then click OK
- Go to View tab -> Macro -> "Stop Recording"
- Your macro is ready! Select a range of cells and hit the shortcut you chose in step 3.