Sunday, June 28, 2015

Excel Tip - Wrap Text


Do you know the secret for wrapping text within a cell when the text you want to wrap is less than the cell width?


ANSWER: Click in a cell and type what you want to appear on the top line of the cell.  Press Alt+Enter and then type what you want on the next line.  If more lines are needed, repeat Alt+Enter, if finished, press ENTER.

EXAMPLE: 

Make sure the cell width is wide enough to display the longest line.  Type Bev Manwiller; press Alt+Enter; type phone number; press Alt+Enter; type website; press Enter.