Excel Tips Tutorial: How to Display Text at a 45 Degree Angle (Diagonal Text)
Many Excel users like to display the content within their column headers at an angle or diagonally across the cell. This gives the worksheet a more professional and visually stimulating appearance. To format your text diagonally at a 45 degree angle simply follow the steps below.
Step 1: Select the cells of range of cells where you want to format your text to be displayed diagonally.
Step 2: Activate the Home tab and locate the alignment group.
Step 3: In the alignment group locate and click the orientation button and and drop down menu will appear offering you many different text orientation options.
Step 4: Select either Angle Counterclockwise or Angle Clockwise depending on which angle you would like you would like you text to be present diagonally.
Choosing a Specific Angle Degree for your Text Orientation
Your text doesn't have to be displayed at a 45 degree angle. You could display it at whatever angle you want. To do this follow the steps below.
Step 1: Press CTRL+1 on your keyboard to open the Format Cells dialog box.
Step 2: Make sure the Alignment tab is activated.
Step 3: In the top right of the dialog box there will be a group labeled Orientation with what looks like half a clock, and a spinner button where you can choose the degree of the angle you would like your text to be displayed. Use the Degree spinner button to choose the degree of the angle you prefer your text to be displayed at and click OK.