By Marlo Anderson – The Tech Ranch
Typing an address in Excel and Enter keeps jumping to the next cell? Press Alt + Enter to start a new line inside the same cell.
The Shortcut
- Alt + Enter: new line inside a cell
- Works in Excel and Google Sheets on Windows
- Mac Excel: Option + ⌘ + Return
Bonus Tip: Fill Many Cells at Once
Select the cells, type the entry once and press Ctrl + Enter. Every selected cell gets it.
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.
