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.

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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.