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.

word wrap text

  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.

word auto height

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


Posted in:
About the Author

Carol Bratt

Carol holds A+, MCP, and MOS computer certifications and is the resident DCT Office expert. She trains the staffs of small law firms in the use of Microsoft Office applications and has authored many books covering Microsoft Office as well as written articles for Infopackets, TechnoLawyer, and Digital Harbor. For more Microsoft Office tips visit Carol's Corner Office or follow Carol on FaceBook and Twitter.