Home How to rotate text in Excel

How to rotate text in Excel

A DataSherpas Quick Tip.

In this quick tip we will show you how to rotate text in Excel. The process is very simple and quick, but we are sure that you will use this feature regularly to style and format your Excel spreadsheets.

In our example below we have a large cell containing data and to the left of that cell we have another cell that we want to use as a heading or title for the data so the end user of the spreadsheet can quickly see what the data relates to or what is important about the data.

Text to be rotated

At the moment the heading looks a bit strange in the default position. It would be better if this heading were rotated vertically and aligned properly so it catches the eye a little more and improves the overall formatting of the Excel spreadsheet.

First let’s rotate the text in the heading cell so it is presented vertically from top to bottom.

There are many routes available in Excel to achieve the same result. We will demonstrate our preferred method below and then list the alternatives.

Rotating Text Vertically

First click in the cell where the text is to be rotated.

Now click your right side mouse button and choose “Format Cells” from the menu.

Right click and format cells

In the dialogue box that appears choose the “Alignment” tab.

Go to the alignment tab

Next click on the box labelled “Text” under the “Orientation” panel. The text box should change color to green.

Click the box labelled text

Next click OK.

The text in your cell should be vertically orientated.

Text is now rotated

As we mentioned above there are a couple of other ways to achieve the same result:

  1. Click in the cell where the text is to be rotated, then go to the “Format” menu at the top of Excel, then choose the sub menu option “Cells”.
  2. Click in the cell where the text is to be rotated and then choose the “orientation” shortcut from the Excel ribbon / toolbar: 

Change orientation

Now you may want to improve the styling of the text that has just been rotated.

Maybe capitalise the letters, change the font color, add a background.

Also try aligning the text horizontally and vertically in the cell.

Formatting

Rotating text to other angles

You may have noticed you can also change the orientation of the text in your cell to be at differing angles, not just vertically.

Let’s say we want to angle the text in our cell at 45 degrees.

Click your right mouse button again and go to the “Format Cells” option.

Now instead of clicking in the “Text” box in the orientation section, click on the dial (to the right of the text box) and drag the pointer to the 2  o’ clock position of the dial and click OK.

choosing an angle

The text in your cell should now be angled at 45 degrees across the cell.

45 degrees

Of course instead of dragging the pointer to the 45 degree angle you can type the specific angle into the “Degrees” box.

Manually selecting the angle

You are not limited to just 45 degrees. Have a go at experimenting with other angles and even negative numbers to have the text angled downwards.

Change the direction..

Other Resources

  1. Our Youtube video explaining the process for rotating text in Excel.
  2. Official Microsoft help pages on rotating and aligning text in Excel.