How to rotate text in Excel 2022

Rotate a Text: The Excel features allow the user to change the text orientation in a cell. With the help of the “Rotate” option, the user can rotate the text as per their convenience.

Inhaltsverzeichnis Show

Rotate a Text in Excel:
Related articles:
Rotating Text using Ribbon Alignment option
Using the Ribbon Format cells dialog box
Using keyboard shortcuts
Using the VBA code

Rotate a Text in Excel:

Open a New Excel Workbook.
Type any value in the cell.
Select the cell that you want to rotate.

Sample Text

Right-Click on the cell and then select the Format Cells option.

Select Format Cells Option

Now, the Format Cells window will open.

Format Cells Window

In the Format Cells window, choose the number of degrees to rotate the text.
Now, you can find the changes in the selected text.

Text After the rotation

Verdict:

We hope that this article illustrated the complete information about Text Rotation in Excel 365. Mention your queries/suggestions in the comment section. Stay connected to get instant updates. Thank you for visiting our website GeekExcel.

There are several ways to rotate texts in excel. They include using the ribbon Format dialog box, keyboard shortcuts, and default settings by changing the text orientation back to Horizontal.

Rotating Text using Ribbon Alignment option

Follow these steps:

1. Choose all the cells with headers

2. Click on the Home tab

3. Click on the Orientation icon on the Alignment group

4. Click on 'Angle counterclockwise option from the option that pops up

Note

These steps rotate the Text in the selected cells by 45°. You can also choose options like Angle clockwise or Rotate Text up. The above step is easy and a quick way to rotate texts in a cell, although it limits one to rotations more than 45°

Using the Ribbon Format cells dialog box

Follow these steps :

1. Make a selection of all the cells with headers

2. Click on the Home tab

3. Click the Orientation icon from the Alignment group

4. Click on the Format cells Alignment option

5. Enter the degrees that you want the Text to be rotated

6. Close the dialog box

Note

Alternatively, you can click on the red dot in the orientation option and use a mouse to get the desired alignment.

Using keyboard shortcuts

You start by pressing ALT, H, F, Q; when you start pressing, you will note where the shortcut is leading you. H stands for Home tab, F stands for formatting, and FQ combination will open the orientation drop-down menu. The drop-down menu will indicate keyboard shortcuts for the text rotation. The key combinations will finally be as follows:

ALT+H+F+Q+O

It will rotate the text angle counterclockwise

ALT+H+F+Q+L

It will rotate the text angle clockwise

ALT+H+F+Q+V

For vertical Text

ALT+H+ F+Q +U

It will rotate the Text upward (from bottom to top)

ALT+H+F+Q+D

It will rotate the Text downward (from top to bottom)

ALT+H+F+Q+M/CTRL +1

It will open the Format cells dialog box

NOTE

The keyboard shortcut does save time. However, it is a long keyboard shortcut.

Using the default settings by changing text orientation back to Horizontal

To remove the rotated Text and change it back to regular horizontal Text, go back to disable the current setting. It can be done by clicking on a similar option in the ribbon again. An example is when you have the Text In the Angle counterclockwise setting, you can go to the same option and click on it again

Alternatively, you can use the alignment dialog box and set the orientation degrees to zero.