Keyboard shortcut to extend Google Sheet formula down to the next cell?

Question

I have a formula in cell A2, say, in a Google Sheet.

With cell A2 selected, is there a keyboard shortcut to extend that formula down to cell A3?

Raystafarian · Accepted Answer · 2016-04-05 11:44:26Z

9

Yes, but it's a series -

Shift + Alt + Down (select)

then:

Ctrl D (fill)

answered Apr 5, 2016 at 11:44

Raystafarian

1,3468 silver badges16 bronze badges

If there are changes in the contents of the column the Shift+Alt+Down will stop selecting at the change. (For instance gaps in input where there was only blanks in that column) Continuing to hit Down-Arrow will eventually go to the end, but it can be tiresome also.
– Jim Garner
Commented Nov 12, 2018 at 20:10
What about for mac?
– Rbar
Commented Aug 2, 2019 at 16:52
Fill is ⌘-D on Macs.
– heiner
Commented Apr 12, 2021 at 18:35
If I have "1, 2, 3" and extend, it'll do 4, 5, 6.... but with ctrl+d it just puts 1 in all of them.
– Ehsan Kia
Commented Feb 2, 2023 at 1:35

Add a comment |

1 Answer 1