To insert a line break (i.e.

a new line) inside a cell, it’s crucial that you use a shortcut.

Move cursor to break point

Move cursor to break point

Move cursor to break point

Move cursor to break point

Move cursor to break point

Type Alt + Enter

Make sure Wrap Text is enabled

Video thumbnail for Why VLOOKUP is better than nested IFs

Video thumbnail for How to make a nested IF formula easier to read

Video thumbnail for Shortcuts for editing cells