|
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 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... |
Copyright 1999-2018 (c) Shyam Pillai. All rights reserved.