We place the cursor to the left of “123”.įigure 2. Suppose we want to insert a hard return before “123” in cell C4.Enter the edit mode by pressing F2 or double-clicking the cell we want to edit.In order to make a hard return or the equivalent of a carriage return, we simply follow these steps: It can be done through the keyboard shortcut: Hard return, also referred to as a paragraph or line break, causes a line to break at a certain point, and begins the next line with the remaining text string.

This article assists all levels of Excel users on how to add a hard return in a cell. We can display all the contents of column C above by doing any of these methods: While working with Excel, we sometimes enter long text strings in a cell so that the contents either spill over to the empty adjacent cells, or are visually clipped such that we cannot see the rest of the contents.