For Seniors: How to Understand Excel Functions
For Seniors: How to Identify the Parts of an Excel Chart
For Seniors: How to Insert and Delete Rows and Columns in an Excel Worksheet

For Seniors: How to Row Height and Column Width in Microsoft Excel

You can adjust the row and column sizes in a Microsoft Excel spreadsheet to create space between columns or rows of text. That feature is handy because by default, each column and row in an Excel spreadsheet is the same width.

If you type text that exceeds the column width, one of two things happens:

  • If the cell to the right is blank: The text overflows into it.

  • If the cell to the right isn’t blank: The text appears cut off (truncated). The full text is still stored there, though.

    image0.jpg

To fix such a problem, you must widen the column:

  • To widen the column exactly enough to hold the longest entry in it: Double-click the divider between the column headers or choose Home→Cells→Format→AutoFit Column Width.

  • To widen the column manually: Drag the divider between the column headers.

    image1.jpg

You can also make a column narrower; just drag to the left, rather than to the right.

This process also works with row heights. You can drag the divider between two row numbers to change the row height or double-click the divider to autofit to the content.

Row heights adjust automatically to fit the tallest text in them, so you don’t have to worry about text being vertically truncated in rows — usually. If you manually adjust the height of a row and then put some larger text into it, the larger text may become truncated because the row height has been fixed. To make it autofit again, choose Home→Cells→Format→AutoFit Row Height.

  • Add a Comment
  • Print
  • Share
blog comments powered by Disqus
For Seniors: How to Assign a Color to an Excel Sheet Tab
For Seniors: How to Apply Gridlines or Borders in Microsoft Excel
For Seniors: How to Format an Excel Chart
For Seniors: How to Move and Copy Cell Content in an Excel Worksheet
For Seniors: How to Fill Color in Microsoft Excel
Advertisement

Inside Dummies.com