Saturday, September 2, 2017

Fit more text in column headings

Fit more text in column headings

Sometimes the label at the top of a column is wider than the data that is stored in the column. You can expand a column to match the size of the heading. However, that frequently means that you won't see as many columns on a page. When wrapping or vertically formatting text doesn't resolve this problem, you can use rotated text and cell borders instead.

Rotate text and borders in column headings

You can angle text to fit long headings into small columns.

Example of angled column headings

  1. Select the cells that you want to format.

  2. On the Home tab, click Format, and then click Format Cells.

  3. On the Border tab, apply vertical borders to the left, right, and middle of the range.

  4. On the Alignment tab, in the Orientation box, enter a degree value or drag the indicator to the angle that you want.

    Note: A positive angle between 30 and 60 degrees usually works well.

  5. Under Horizontal alignment, select Center, and then click OK.

    Tip: To reduce all the columns to their smallest possible width, select them. Then on the Home tab, click Format, and then click AutoFit Column Width.

Split a column to create a dual-label corner cell

You can use an angled border to create a dual-label corner cell such as the one shown here.

Example showing two values in one cell

  1. To put text in the upper-right part of the cell, select the cell that you want to format, and then type 10 space characters. You can adjust this later, as needed.

  2. Type the first label, which corresponds to the column labels.

  3. To create two line breaks in the cell, hold down CONTROL + OPTION and press RETURN two times.

  4. Type the second label, which corresponds to the row labels down the left side of the table, and then press RETURN . You can adjust this later, as needed.

  5. Again, select the cell that you want to format.

  6. On the Home tab, click Format, and then click Format Cells.

  7. Under Border, click the upper-left-to-lower-right angled border button.

    Upper left to lower right border option

Rotate text and borders in column headings

You can angle text to fit long headings into small columns.

Angle text to fit

  1. Select the cells that you want to format.

  2. On the Format menu, click Cells.

  3. On the Border tab, apply vertical borders to the left, right, and middle of the range.

  4. On the Alignment tab, in the Orientation box, enter a degree value or drag the indicator to the angle that you want.

    Note: A positive angle between 30 and 60 degrees usually works well.

  5. Under Text alignment, on the Horizontal pop-up menu, click Center, and then click OK.

    Tip: To reduce all the columns to their smallest possible width, select them, point to Column on the Format menu, and then click AutoFit Selection.

Split a column to create a dual-label corner cell

You can use an angled border to create a dual-label corner cell such as the one shown here.

Dual-label column

  1. To put text in the upper-right part of the cell, select the cell that you want to format, and then type 10 space characters. You can adjust this later, as needed.

  2. Type the first label, which corresponds to the column labels.

  3. To create two line breaks in the cell, hold down CONTROL + OPTION and press RETURN two times.

  4. Type the second label, which corresponds to the row labels down the left side of the table, and then press RETURN . You can adjust this later, as needed.

  5. Again, select the cell that you want to format.

  6. On the Format menu, click Cells.

  7. Under Border, click the upper-left-to-lower-right angled border button.

See Also

Fix data that is cut off in cells

Change column width or row height

No comments:

Post a Comment