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
  • 361

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

Lernkurve
  • 2,052