OfficeTips Home || VBA Section || General Section ||  Download Section  ||  Privacy Policy

Wrap text as you type

If U have to enter a long text in a cell, you try to adjust it logically in two, three or more lines in a row by adjusting the font size, style or format. A simpler way to do this is to insert a line break by pressing Alt+Enter at the appropriate place in the cell.

Example: If I wanted to key in "The quick brown fox jumps over the lazy dog."  in the following manner into one cell...
The quick brown
fox jumps over
the lazy dog.

The typical way would be to enter the text into the cell. Then right-click on the cell. Select Format cell. Click on the Alignment tab. Tick Word wrap.

Now use the above shortcut to arrive at the same result quickly by typing in the following manner...
The quick brown
Alt+Enter
fox jumps over Alt+Enter
the lazy dog. Enter

 

Copyright 1999-2014 (c) Shyam Pillai. All rights reserved.