How to skip a line in Excel
By
SpreadCheaters
Suppose we have a data set that has the home addresses of people just like shown below.
We want to insert a line break after each comma in the cell. To achieve this follow these steps.
In comparison to Microsoft Word, which is a document typing software, Microsoft Excel is not a very friendly software when it comes to typing long rows of data. Excel does not offer the feature to go to a new line in a straightforward way. However, sometimes we need to insert a line break in the data that includes multiple parts of a string and we want to show the data in multiple lines separately e.g; the home address of someone. So, in this tutorial we will see how to jump to a new line or insert a line break while typing in a cell.
Step 1 – Select the cell and enter editing mode
– Select the cell where you want to insert a line break then either double click or press “F2” to enter in editing mode.
– When the editing mode will be activated, you will see the cursor blinking in that cell.
Step 2 – Select the location to insert line break
– Now that we have entered the editing mode in the cell. Go to the location where you want to enter the line break i.e. right after the comma.
Step 3 – Insert the Line Break
– Now that we are at the location where we wanted to enter the line break, we have to press a combination of two keys i.e. ALT+ENTER and that will insert the line break at the desired location in the cell as shown above;
