Alt + Enter = Insert a line in a cell

Keyboard Shortcut

By Neale Blackwood

To insert a line within a cell hold the Alt key (next to your space bar) and press Enter. This inserts a fixed line break in the cell.

This operates differently to the Wrap Text format.

Wrap Text will break depending on the length of the words and the width of the column.

The Alt + Enter method will break in the spot you added Alt + Enter providing the column is wide enough.

This method is ideal for data lists that require a single heading row.

Instead of using two rows for the headings (not a good practice) you can use one row and get the same effect as two rows.

Free Download

First published: CPA AUSTRALIA Website 2008

Amended to include workbook provided by Wyn Hopkins 2014.