Reuse: Quickly insert complex formulas, charts and anything that you have used before Encrypt Cells with password Create Mailing List and send emails.The Best Office Productivity Tools Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80% Then select the cells excluding the first row data, and click Home > Borders > All Borders.

Then the cells and borders are rotated to 45 degrees.Ħ. In the Format Cells dialog, under Alignment tab, select Center in the Horizontal drop down list, and click OK. Then right click on the rotated cells and click Format Cells from the context menu. In the Format Cells dialog, check Border tab, select the middle one, and click OK. Select the first row data including adjacent blank cells, click Home > Orientation > Format Cell Alignment. 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.ġ.

If you are interested in this, please go on to get detail. Have you ever imaged to rotate text and cell border to 45 degrees in an Excel table as below screenshot shown? In this article, I will talk about solving this job step by step. How to rotate text and cell border to 45 degrees in Excel?

Angle text in excel