Enter data and stay in the same cell
Master this Excel shortcut with our comprehensive guide
Data Entry Shortcuts in Excel
Ctrl + Enter
⌘ + Enter
How to Use This Shortcut
Keyboard Shortcut
Ctrl + Enter
Instructions
1. Select a cell or range
2. Type your data
3. Press Ctrl + Enter
4. The value is entered but the selection stays in place
2. Type your data
3. Press Ctrl + Enter
4. The value is entered but the selection stays in place
Keyboard Shortcut
⌘ + Enter
Instructions
1. Select a cell or range
2. Type data
3. Press Command + Enter
4. Data is entered but the selection does not move
2. Type data
3. Press Command + Enter
4. Data is entered but the selection does not move
💡 Pro Tip: Use this when filling multiple selected cells with the same entry.
Quick Actions
More Data Entry Shortcuts in Excel
Shift + Enter