Keyboard shortcut for writing formula in many cells

[OldManExcellor]

Say I have a formula in B1 that is =A1+1.

Now I want to copy this formula into all Bx cells all the way down to B60000.

Is there a clever keyboard shortcut for this?

 

[borgem]

If you highlight B1 down to B6000 and hit ctrl+d it will copy the formula down, but that only saves you a few keystrokes vs. ctrl+c,ctrl+v.

 

[jdmc45]

Say I have a formula in B1 that is =A1+1.

Now I want to copy this formula into all Bx cells all the way down to B60000.

Is there a clever keyboard shortcut for this?

Ctrl + shift + down + ctrl + d

No mouse needed