How to Rotate Text in Excel: The Easiest Ways to Do it

The first question that comes to mind when it comes to rotating texts in Excel is, “Why?” Well, apart from the aesthetic value it adds to the worksheet, it helps to save up space and highlight a particular set of cells.

But this time around, we’re going to focus on the “How.” Rotating texts in an Excel worksheet isn’t all that difficult. However, you might want to know the right ways to do it. In this writeup, we’ll be covering the most convenient ways to rotate texts in a cell.

So, without further ado, let’s get into discussing the methods and how you can apply them.

4 Easy Ways to Rotate Text in Excel

Now, it’s be best if you follow each procedure step by step. Some methods might seem just right for your task and work style. While the others might seem slightly difficult. So, read thoroughly to find out which method suits you best.

Rotate Text with Ribbon Alignment

This one is probably the easiest method there is. It doesn’t grant full liberty in rotation, but it does get the job done straight away.

1. The first thing you need to do is, select the cells that you want to rotate the texts of.

2. Select the home tab on top (This is selected by default).

3. Then go to the Alignment group and select the Orientation dropdown menu.

4. There you’ll want to choose the Angle Counterclockwise option.

Rotate text with ribbon alignment 1

5. This will rotate the cells and the texts within them 45 degrees counter clockwise.

Rotate text with ribbon alignment 2

6. You can explore the other options in the Orientation dropdown menu. But those are hardly needed in most cases.

Rotate Text with Ribbon Format Cells Dialog Box

This method might not get as rapidly executed as the last one. But I’d rather not call it difficult. In fact, it offers you more control in the rotation procedure. So, let’s see how it’s done.

1. Just like the previous method we discussed, go to the home tab and select the Orientation dropdown menu from the alignment group.

2. This time, you’ll want to select the Format Cell Alignment option.

3. Within the popup window you can choose the degrees you want the texts to be rotated in the Orientation section.

Rotate text with ribbon format cells dialog box

4. You can drag the cursor on the Orientation section’s red dot to get the desired rotation as well.

Rotate Texts Using Keyboard Shortcuts

Now, this is for those who need to get the job done almost instantly. This really helps if you need to rotate cells in excel on a regular basis. All you have to do is, press the buttons below.

Alt + H + F + Q + O (You can press one after the other while holding Alt)

This is without a doubt the fastest way to execute the task.

Using VBA Code

Well, the three simple procedures that I discussed beforehand work just fine. But still, if you want to use a VBA code, it’s very much possible.

Just press Alt + F11 to bring up the VBA window, there, in the insert menu, you’ll find module. All you have to do is, enter the code there and run it. The code is given below:

Sub RotateCellRange()
‘Declare variables
Dim rng As Range
Dim orientation As Double
‘Ingore errors if user clicks Cancel or X
On Error Resume Next
‘Input Box to select cell Range
Set rng = Application.InputBox(Prompt:=”Select cell range”, Title:=”Cell range”, Type:=8)
‘Input Box to enter the celllink offset
orientation = Application.InputBox(“Set the orientation angle”, “Orientation angle”)
‘Exit the code if user clicks Cancel or X
If Err.Number <> 0 Then Exit Sub
‘Turn error checking back on
On Error GoTo 0
rng.HorizontalAlignment = xlGeneral
rng.VerticalAlignment = xlBottom
rng.WrapText = False
rng.orientation = orientation
rng.ShrinkToFit = True
rng.MergeCells = False
End Sub

How to Change the Orientation Back to Normal

Now that we’ve covered all the possible ways to rotate cells in Excel, let’s discover how to set them back the way they were. It’s basically reversing the procedures. Let’s discuss.

1. Remember rotating the cells Counter Clockwise? All you have to do is, select the cells again and go to the Alignment group under the Home tab. Select Angle Counterclockwise again from the Orientation dropdown menu. The cells should return back to normal.

2. If we go back to the second method, we selected the Format Cell Alignment Option from the Orientation dropdown menu and changed the degrees to achieve the desired rotation. Now, all you have to do is, change the value to zero and the cells should turn back to normal.

3. After rotating the cells, if you want to go back instantly, all you have to do is, press Ctrl + Z. That’ll reconvert the cell alignment and bring things back to normal.

Why Rotate Texts in Excel?

We’ve already learned the ways we can rotate texts in Excel. Let’s note a few points on why it might come in handy.

  • Rotating texts in cells saves space in the worksheet.
  • It helps to avoid unnecessary scrolling on the sheets during observation.
  • Rotating texts can add a visual appeal to the headings in the worksheet.

Wrap Up

I believe at this point; we’ve given you all the necessary information regarding “How to rotate text in Excel.” It’s not about completion in the end. It’s about utility. I earnestly hope that this article helped you find what you were looking for. Let’s not drag this along any further then.

I hope you enjoyed the read. Farewell.

Similar Articles:

Leave a Comment