|  

» Manually Wrapping Text in a Cell

Using keyboard shortcuts

To manually wrap text:

1. Type the following text into a cell: "F1 Get the Most out of Excel! The Ultimate Excel Tip Help Guide".
2. In the Formula Bar, place the cursor after the word "Excel!".
3. Press Alt+ Enter.

To cancel manual text wrapping:

1. In the Formula Bar, place the cursor where you caused the text to wrap, that is, before the word "The".
2. Press Delete.



Rate This Tip
12 34 5
Rating: 3.74     Views: 30251
Manually wrapping text in cell (aka inserting newline, carriage return within cell)
Craig Kiser
Alt Enter - perfect easy command
Click here to post comment
For Registered Users
Name
Comment Title
Comments