Inserting a hard return through Alt + Enter Only “4th Floor” remains in the first line of text while “123 8th Avenue New York” is now on the second level.įigure 3. Enter edit mode and place cursor at specific position 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. Adjust the column width to show the contentsįigure 1.
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.
