

In that group, you will see a button with an a and b and an arrow all on an angle. Click the Orientation button again and choose Angle Counterclockwise again to turn off the format from range B7:D7. On the Home tab of the Ribbon, find the Alignment group.Text alignment helps when you need to make more room on a page. Select the cells you want to rotate, click Home > Orientation > Angle Counterclockwise. Supposing you have a table as below screenshot shown, You can rotate the first row and border to 45 degrees with following steps.

