Menu Monday - Wrap Text

If you tend to be a little "wordy" like me, you might find the "Wrap Text" function in Excel quite handy.  This is very useful when you have a cell with multiple characters and you want to see all of the text, but you don't want your column width to be really large.

 To use the Wrap Text function:

-Click on the cell where you want the text wrapped

-Click on the Home tab

-Click on the Wrap Text icon in the Alignment section

 
 

-Now you will see that your text has wrapped around

 Example:

-In this scenario, I want to wrap the text in A1, so that "Day of the Week" fits within the column width constraints already set

 

-Click on cell A1

-Click on the Home tab

-Click on the Wrap Text icon in the Alignment section

 

-Now you can see that "Day of the Week" fits within the column width

 

-You can also see that the Wrap Text icon on the Home tab is highlighted to signify that the function is on in this particular cell

 

Note: This function can be used before or after text has been entered into the cell.  Also, multiple cells, rows, columns or even the whole worksheet can be selected and you and turn the Wrap Text function on or off for all at one time.

Excel ya later!