How to Wrap in Excel

Step-by-Step Guide

1. 1

   Step 1: Launch Microsoft Excel.

   Type out or copy and paste the text into the cell.
   
   It may not appear to completely fit, but, even if the complete entry is not visible within the cell, it is still there. , Check the "Wrap Text" option on the Alignment tab of the "Format Cells" window and then click the OK button to close the window. , The cell is not large enough if the text appears to be cut off.
   
   Enlarge the entire row in which the cell is located by clicking in between the row numbers and dragging down until all text is displayed.
   
   Add more cells to the original set of merged cells to enlarge the cell.
   
   Click the original merged cell and drag either down or to the right to highlight additional cells.
   
   Right-click on the highlighted group of cells and choose the "Format Cells" option.
   
   Note the grayed out check in the "Merge Cells" box.
   
   Uncheck and recheck until the mark is no longer gray.
2. 2

   Step 2: Determine where you will place the text.

3. 3

   Step 3: Click and drag to highlight the cells across which the text will be placed.

4. 4

   Step 4: Right-click on the highlighted range and select the "Format Cells" option near the bottom of the pop-up window.

5. 5

   Step 5: Choose the Alignment tab of the Format Cells window.

6. 6

   Step 6: Check the "Merge Cells" option and then click the OK button to close the window.

7. 7

   Step 7: Enter the desired text into this cell.

8. 8

   Step 8: Wrap the text in the cell by right-clicking on the merged cells and again choosing "Format Cells."

9. 9

   Step 9: Re-size the cell in order to accommodate the quantity of text

10. 10

    Step 10: if necessary.

Detailed Guide

About the Author