Excel Shortcut: Enter Data and Stay in Same Cell

About This Shortcut

Enter Data and Stay in Same Cell – Ctrl + Enter completes the entry in every cell in the selected range.

Keybord Shortcut key

• Window: Ctrl + Enter
• Mac: Ctrl + Return

Example: