By Marlo Anderson – The Tech Ranch
Scrolling down a spreadsheet with hundreds of rows to find the end? Click a cell and press Ctrl + Down Arrow. You land on the last row of your data in one press.
The Shortcut
- Ctrl + Down Arrow: jump to the last row
- Ctrl + Up Arrow: jump back to the top
- Left and right arrows work too
- Works in Google Sheets and Microsoft Excel
- Mac: ⌘ + Arrow
Bonus Tip: Add Shift to Select
Press Ctrl + Shift + Down Arrow to select everything from where you are to the end of your data. Select a column of numbers and the sum appears in the bottom corner. On a Mac, use ⌘ + Shift + Arrow.
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.
