When i was working as a permanent analyst, one of my jobs was come prepare weekly reports for clients and also stakeholders.

You are watching: How to rotate text 180 degrees in excel

As a part of it, I had actually to make certain my reports were simple to review and likewise take much less screen room (apparently, clients hate scrolling back and forth).

And the use of rotating text came in beneficial in such reports.

It’s especially useful when you have actually a larger heading and a small number (as shown below). Here, headers in heat 1 take less an are as these space at an edge (as compared to once they room horizontal).

In this tutorial, i will show you the step-by-step procedure to conveniently rotate text in Excel.


This tutorial Covers:


Rotate text Using Ribbon Alignment Options

Suppose you have actually a dataset as displayed below and you want to revolve the headings in the an initial row.

Below space the procedures to revolve the text in the cells:

select all the cells (that has actually the headers) Click the home tab
*
In the Alignment group, click the ‘Orientation’ icon In the choices that show up, click on the ‘Angle Counterclockwise’ alternative

The above steps would rotate the text in the selected cell by 45 degrees.

You can also choose the options such as Angle Clockwise or rotate Text Up. While there are some other options as well, ns don’t usage them (and not sure if everyone does).

While this is a quick method to turn text in a cell, it offers you limited options. For example, what if you want the edge of the rotation a little an ext than 45 levels (say 60 degrees).

You have the right to do that as well, however for that, you must use the next technique covered in this tutorial.

Rotate text Using Ribbon layout Cells Dialog Box

This is a slightly longer an approach (takes a few extra clicks), yet gives friend a lot an ext control.

Suppose you have a dataset as presented below and you desire to turn the headings in the very first row.

Below are the measures to perform this:

select all the cell (that has the headers) Click the house tab In the Alignment group, click the ‘Orientation’ symbol In the options that display up, click the ‘Format cell Alignment’ choice In the orientation section, go into the degrees by which you desire the message to be rotated.
*
close the dialog box

You can additionally click on the red dot in the Orientation option and also use the computer mouse to get the desired alignment.

*

Keyboard shortcut to revolve Text in Excel

If rotating the message is something you have to do a lot of often, getting used come the faster way to execute this could save you part time.

Below is the keyboard shortcut to rotate text in the selected cells

ALT + H + F + Q + O (press one after ~ the other) It’s a long keyboard shortcut, but still, the fastest way if you need to use this setting regularly.

Change the text Orientation ago to Horizontal (Default State)

If you want to eliminate the rotated text and also get ago the regular horizontal text, you need to go ago and disable the current setting (which you can do by clicking the same option in the ribbon again).

For example, if you have actually the text in the angle Counterclockwise setting, walk to the exact same option and click on the again (it functions as a toggle).

See more: How Much Is 999 Copper Worth, Copper Ounce Price Calculator

Or you can use the Alignment dialog box (the second an approach covered in this tutorial) and set the orientation degrees to 0.