How to Adjust Row Heights for Text in Excel 2010

You can easily put more text into a cell than will display properly and while you can widen your column to make the text fit, there are some instances where this might not be advisable. Instead, you can wrap your text within the cell such that your cell height will be increased to display all your text.

Follow the steps below to learn now:

  1. Select the cells whose formatting you would like to affect.
  2. Click CTRL + Shift + F to display the Format Cells dialog.
  3. Click on the Alignment tab.
  4. Be certain the Wrap Text check box has been selected.

  1. Click OK .

Remember now, that your row height will only increase automatically if you have not explicitly specified the row height.

If the row height does not expand to fit the contents of your cell, after following the steps above:

  1. Select your row.
  2. Be certain the Home tab of your Ribbon is displayed.
  3. In the Cells group, click Format to display a drop-down menu.
  4. Select AutoFit Row Height.

Your text should now be wrapped within your cell and displayed properly.


Exit mobile version


Get great content like this delivered to your inbox!

It's free, convenient, and delivered right to your inbox! We do not spam and we will not share your address. Period!