If rotating the text is something you need to do a lot often, getting used to the shortcut to do this could save you some time.Д«elow is the keyboard shortcut to rotate text in the selected cells ALT + H + F + Q + O (press one after the other) Keyboard Shortcut to Rotate Text in Excel You can also click on the red dot in the Orientation option and use the mouse to get the desired alignment. In the orientation section, enter the degrees by which you want the text to be rotated.

In the options that show up, click on the вЂFormat Cells AlignmentвЂ™ option.This is a slightly longer method (takes a few extra clicks), but gives you a lot more control. Rotate Text Using Ribbon Format Cells Dialog Box You can do that as well, but for that, you need to use the next method covered in this tutorial. For example, what if you want the angle of the rotation a little more than 45 degrees (say 60 degrees). While this is a quick way to rotate text in a cell, it gives you limited options. While there are some other options as well, I donвЂ™t use them (and not sure if anyone does). You can also choose the options such as Angle Clockwise or Rotate Text Up. The above steps would rotate the text in the selected cells by 45 degrees. In the options that show up, click on the вЂAngle CounterclockwiseвЂ™ option.In the Alignment group, click the вЂOrientationвЂ™ icon.Select all the cells (that has the headers).

Suppose you have a dataset as shown below and you want to rotate the headings in the first row.Д«elow are the steps to rotate the text in the cells: Rotate Text Using Ribbon Alignment Options

Change the Text Orientation Back to Horizontal (Default State).

Keyboard Shortcut to Rotate Text in Excel.

Rotate Text Using Ribbon Format Cells Dialog Box.

Rotate Text Using Ribbon Alignment Options.

Excel rotate text in cell