how to go to the next line in excel 2016 for mac in the same cell

How would you do itOne solution used by most excel users is to format the cell with the wrap text option and then adjust the column so that the width is just sufficient to display the description Total Revenue.

This method is not reliable because the presentation will appear that way only in the creators computer.

If this excel file is to be sent to another person, the word Revenue in the line Total Revenue may run off to the next line if the users uses another resolution.

The above method also restrict the user from adjusting the column width at will.

To have a wider column, many users would have to insert sufficient space between Total Revenue and (000).

Unknown to many users, the description can be maintained in two different lines within the cell under all conditions.

Press the button ALT together with the ENTER key.

Note: Depending on where you place the cursor, the space between between the word Revenue and (000) may skew the word Revenue to the left because the space is on the first line or skew the description (000) to the right is the space is on the second line.

To avoid this from happening, we can remove the space as shown Total Revenue(000) prior to splitting the text into 2 lines.

How To Go To The Next Line In Excel 2016 For Mac In The Same Cell