Split a column to create a dual-label corner cell

Newer versions

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 regulator.
Upper left to lower right border option

Office 2011

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.

Leave a comment

Your email address will not be published. Required fields are marked *