Forum Discussion

adrian1337's avatar
adrian1337
Copper Contributor
Jul 19, 2022

Autofill WITHOUT mouse

Hello! I'm trying to use autofill without my mouse.

 

Right now I need to use the mouse and use the black cross to drag down to autofill with series.

 

However I want to do this with a shortcut on the keypad.

 

The closest I have come to is by:

Choose cell

Shift + Down (as many times as needed)

Ctrl + D

However when I do this, the first cell is only copied to the others. I want it to do it in a series.

 

For example:

First cell = "Test_1"

I want all the other cells other to auto-increase by one to "Test_2", "Test_3" etc.

 

Thanks!

2 Replies

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor

    adrian1337 

    Not sure if simple shortcut exists. You may select the range to fill staring form first cell, Alt+E+I+S, select within box AutoFill with tabs, Enter.

    Above shortcut from former time, now default combination Alt+H+F+I+S

Resources