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?


Yes, but it's a series -

Shift + Alt + Down (select)


Ctrl D (fill)

| improve this answer | |
  • 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 Nov 12 '18 at 20:10
  • What about for mac? – Rbar Aug 2 '19 at 16:52

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.