1

I would like to extend a sequential pattern in Excel as in the link below.

http://www.worldstart.com/ms-excel-extending-your-sequential-pattern/

However, is there a way to do that without using a mouse?

Thank you for help.

emnha
  • 331
  • 2
  • 4
  • 15
  • I believe this is a duplicate. http://superuser.com/questions/270018/excel-auto-fill-a-series-without-mouse-keyboard-only – Dale May 16 '16 at 13:47
  • Yes, you are right. Thank you. I couldn't find it. – emnha May 16 '16 at 14:04

1 Answers1

1

[...] is there a way to do that without using a mouse?

Yes, there is.

Keyboard shortcut

In Excel 2013 select the range like this:

Excel Fill Series Before

And then press Alt, H, F, I, S, Enter.

Explanation

  1. Press Alt to activate the accelerator keys,
  2. followed by H to select the Home ribbon,
  3. followed by F,I to select the Fill button
  4. followed by S to select the Series menu entry
  5. followed by Enter to execute the command.

Result

The result looks like this:

Excel Fill Series After

Community
  • 1
Lernkurve
  • 1,952
  • 7
  • 27
  • 41