How to add elbow to the table

This tip describes how to place into one cell both column and row header known as elbow.

To create an elbow, follow these steps:

    1.    Type the column heading and row heading in the corner cell.

    2.    Place the cursor between the two words, press Alt+Enter:

Elbow in Excel 2007

    3.    Adjust the column heading to the right.

    4.    Place a diagonal line between the two using the borders option to create a result similar to:

Elbow in Excel 2007

How to add borders, see Apply or remove cell borders.

Thank you for visiting OfficeToolTips

We are glad to help you in your work. However, you are using ad blocker and our efforts will not be rewarded.

Please consider disabling ad blocker before continuing the reading.