By Marlo Anderson – The Tech Ranch
Got a formula in the top row and need it in every row below? Select that cell and the cells beneath it, then press Ctrl + D. The whole column fills in one press.
The Shortcut
- Select the top cell and the cells below it
- Press Ctrl + D to fill down
- Works for formulas, text and dates
- Works in Google Sheets and Microsoft Excel
- Mac: ⌘ + D
Bonus Tip: Ctrl + R Fills Right
Need it across instead? Select the cell and the cells to its right, then press Ctrl + R. Mac: ⌘ + R.
More Keyboard Shortcuts, Explained
This is part of my Keyboard Shortcuts Explained series: quick, plain-English tips that make everyday computer work faster. Watch the whole series on YouTube and subscribe to The Tech Ranch so you don’t miss the next one. Short on time? Here’s the quick Short version.
Found this helpful? Give the video a thumbs up on YouTube. Got a shortcut you can’t live without? Tell me in the YouTube comments and it might show up in a future video.
