For All Your Training Needs                                                                      [ Home ] [ Up ] [ Site Map ] [ Search ]

Microsoft Excel
Control How Text Wraps in a Cell

In Microsoft Excel, you can wrap text in a cell by using the Wrap Text alignment option.  Excel will then position the text in the cell so that it looks like at least two rows of text.  Excel also makes a decision as to where to split the text at the end of rows.

The steps below review how to turn on the Wrap Text option and how to force Excel to wrap the text where you want the split between rows.

In a Microsoft Excel Worksheet

• Select the cells that you wish to contain wrapped text

  • Use the <Shift> key + the left mouse button to select cells that are next to each other

  • Use the <Ctrl> key + the left mouse button to select cells that are not next to each other

• Menu Path

  • Click on the Format menu

  • Select the Cells command

Format Cells Dialog Box

• Click on the Alignment tab

• Click to turn on the Wrap text control option

  • The option is turned on when a check appears in the option box

• Click the OK button

  • If necessary, adjust the column width

Format Cells Dialog Box

Force Excel to Wrap Text Where You Want

• Double click in a cell that contains wrapped text

  • NOTE:  you could instead, single click to select the cell and then single click your mouse in the Formula Bar

  • You will now be in edit mode for that cell

• Position the blinking insertion point where you want the next line of text to begin

• On your keyboard, depress the <Alt> and the <Enter> keys

  • This will force the text that follows the insertion point to appear on the next line within the same cell

• Depress the <Enter> key when you are finished editing the text

NOTE: Click Image Below to Enlarge the View

Send mail to Complete Training Management with questions or comments about this web site.
Copyright © 2002 Complete Training Management
Last modified: December 03, 2008