Insert Line Break in Excel Cell
Use this shortcut to add a line break within a cell, allowing you to display text on multiple lines inside the same cell without splitting it into separate cells.
Keyboard Shortcut
| Windows | Mac |
|---|---|
| Alt + Enter | Ctrl + Option + Enter |
What Does This Shortcut Do?
Pressing the shortcut inserts a line break at the cursor's position within the active cell, creating multiple lines of text without leaving the cell.
How to Use the Shortcut
- Select the cell where you want to insert a line break
- Press F2 to edit the cell
- Place the cursor where you want the new line
- Press Alt + Enter (Windows) or Ctrl + Option + Enter (Mac)
Tips & Best Practices
- Combine with Wrap Text formatting for better visibility
- Useful for addresses, notes, or long text entries
- Maintain proper column width to display all lines
FAQ
- Q: Can I add multiple line breaks?
- Yes, repeat the shortcut wherever you want a new line within the cell.
- Q: Does this affect formulas?
- No, line breaks can be added to text inside formulas using CHAR(10) in combination with Wrap Text.