How to rotate text in Excel easily?

Admin

➥ Go to the beginning of the Free Online Excel Course

Rotating text in Excel may not be the first thing that comes to mind when it comes to spreadsheets. Even so, it is an action that it is better to know how it can be carried outIn the Microsoft office suite we have three procedures that, in all cases, result in the rotation of the text of an Excel document

Excel is one of those productivity tools that we could consider essential, although we don’t always take full advantage of it. Some of its functions go unnoticed to the point that we resort to other programs to solve certain situations. Suppose, for example, that For some reason or special reason, you have to know how to rotate text in Excel. In that case, we teach you how to do it easily, in three ways.

As we said, text rotation may not be the first thing you demand from a spreadsheet program. But even so, it does not hurt to know what are the possibilities we have to achieve these results.

3 Ways to Rotate Text in Excel

Using a keyboard shortcut

The most direct way to proceed in these cases has to do with keyboard shortcuts, as on other occasions. There is, of course, a combination of keys that we can enter to rotate the texts in Excel.

You only have to go to the cell or cells with the contents to rotate, mark them, and press ALT + H + F + Q + O. Obviously, this is a fairly linear method, which doesn’t give you much opportunity for customization. Still, it can get you out of a jam, and if you want a standard rotation, it’s more than fine.

Via Belt Alignment

If what you want is rotate headers, the first row of a dataset, here is a good option. Furthermore, unlike the previous you can configure certain aspects to give it a more personal touch.

Mark the cell or cells with the texts to modify Click on the Home tab, on the left side of the top menu Under the Alignment group, click on the orientation icon with an AB diagonal on it In the following options, select Angle away from clockwise

When you have followed all these steps, the highlighted texts should have rotated in the order of 45°.

Additionally, there are cool features like Rotate Text Up and Angle Clockwise in the Alignment tab. You can select each one according to the circumstances, of course.

Using the Ribbon Format Cells Dialog

Finally, there is a more complex tutorial than the previous ones, which requires several additional clicks along the way. It has the advantage, however, that we can have much more control over the texts.

Mark the cell or cells with the texts to modify Click on the Home tab, on the left side of the top menu In the options that appear, navigate and click on Format cell alignment A new minimalist window will appear. In it go to Alignment, and then navigate to OrientationIn that section, specifically enter the degrees you want the texts to be rotated, or drag the lever until you feel satisfied with the inclination of the contentsWhen you are 100% satisfied, click OK to save changes to cells

Now, if you review the previously highlighted texts, you will notice that they are oriented at the angle set within the Format Cells. As we said, this method is a bit more extensive, but offers superior control.

rotate text excel 3

Rotate text in Excel, conclusions about it

In summary, there you have a series of very basic procedures and tricks, with which you will be able to rotate text in Excel. We consider that surely a keyboard shortcut is the best way out that you can opt for in this case.

If that doesn’t work, well, you have two other possibilities to try and rotate your contents in these spreadsheets.

Next Post

Real Madrid is reinforced as the most valuable and vigorous brand in world football

SOURCE: Brand Finance Football 50 2020 report (24-5-2022). Real Madrid remains the strongest and most valuable football club brand in the world with a value of €1.525M and an elite brand strength score of 94 out of 100. For its part, FC Barcelona remains in the podium of the world […]
Real Madrid is reinforced as the most valuable and vigorous brand in world football