Users may want to rotate text for visibility when working with large tables. Excel has an Orientation feature which enables you to alter the angle during which text values are displayed in cells.
How to Rotate Text in Excel?
Text Alignment using Ribbon Alignment Option
Step-1: Prepare a data table with information outlined below:
Step-2: Select the cell in which you want to rotate the text. Here A1:G1.
Step-3: Go to the Home tab, in the Alignment group, click on the Orientation button.
Click on your desired Orientation.
Result outlined below:
Rotate Text using Ribbon Format Cells Dialogue Box
If you want to rotate text in specific angle, then follow the below steps.
Step-1: Select the cell in which you want to rotate the text.
Step-2: Go to the Home tab, in the Alignment group, click on the Orientation button. Or click on the Alignment Setting icon.
Step-3: Following that, a dialogue box will appear.
Step-4: If we want to rotate the text in 45 degrees angle, then write 45 in the box and select OK
Result outlined below:
Step-5: You can rotate the text by moving the Orientation line by clicking the red dot without writing any value in degrees box
Result outlined below:
Keyboard Shortcut to Rotate Text in Excel
Whenever you need to rotate text frequently, becoming familiar with the shortcut to do so might save time.
The keyboard shortcut for rotating text in the selected cells is shown below.
ALT + H+ F+ Q+ O (press one after the other)
You may be interested: