How to Wrap Text within a Cell

You would need to apply this lesson if you have typed more words in a cell than it can comfortable fit. If you do so without wrapping the text within the cell, here is how it would look: (See the diagram below)

how to wrap text within a cell

 

Follow these steps to wrap text within a cell:

1. Select the cell whose text you want to wrap

how to wrap text within a cell 2

2.  Click the ‘Home’ tab

3.  Click ‘Wrap Text’ command

how to wrap text within a cell 3

Excel wrapped the words in the cell…causing all the text to fit in the selected cell without overlapping into the cell on the left or right.

Lesson 42 - How to Wrap Text within a Cell 4

 

Lesson 43: How to Add a Border to a Range