How to Rotate Text in Cells Excel?

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:

Rotate Text

Step-2: Select the cell in which you want to rotate the text. Here A1:G1.

Rotate Text

Step-3: Go to the Home tab, in the Alignment group, click on the Orientation button.

Rotate Text

Click on your desired Orientation.

Rotate Text

Result outlined below:

Rotate Text

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.

Rotate Text

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

Rotate Text

Result outlined below:

Rotate Text

Step-5: You can rotate the text by moving the Orientation line by clicking the red dot without writing any value in degrees box

Rotate Text

Result outlined below:

Rotate Text

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:

  1. Financial Dashboards
  2. Sales Dashboards
  3. HR Dashboards

Leave a Comment

Your email address will not be published. Required fields are marked *

Categories