How to Rotate Text in Excel: Change Text Direction (2023)
We always look for ways for our data to be substantial and comprehensive as possible. We also want them to be organized and ✨ visually pleasing ✨ for our sake and others.
Microsoft Excel provides us so many ways to improve the format and layout of our content. One of the many ways to do that is to rotate text in your cells 😊
With the rotate text feature in Excel, provide clarity or highlight important content in your spreadsheet. It can also help save up space and add a touch of style to your work.
Let’s get started with this tutorial and learn exactly how to rotate text in Excel 💪
To start, download this free practice workbook we’ve prepared for you to work on.
Table of Contents
Rotate text from the ‘Home’ tab of the ribbon
You can rotate the text in cells either up, down, clockwise, or counterclockwise, or align text vertically. You can even rotate your text to a precise angle depending on your preference.
What matters is that you can use it to improve the overall appearance of your work 😉
Open your practice workbook and you’ll see a sample data table of a Sales Report.
You can observe that the column headers are in a horizontal text orientation and look bigger than the content. As a result, the rest of the report is not visible unless you scroll 😕
So to overcome this, you can rotate the text in the column headers. This will make you save up space to make other texts visible 👀 and give your spreadsheet a more unified look.
One way to rotate texts in cells in Excel is by clicking the Orientation button in the Home Tab. Here’s how 👇
- Select the cells you want to rotate. In our example, the column headers.
- Click the Home Tab.
- In the Alignment group, click the Orientation button.
When you click the Orientation button, you’ll see the following options:
- Angle Counterclockwise
- Angle Clockwise
- Vertical Text
- Rotate Text Up
- Rotate Text Down
These options only rotate text to a preset number of degrees.
Let’s try one and see how it looks.
- Select the Angle counterclockwise orientation option.
This option would rotate the text in the selected cells by 45 degrees.
Make the content look better by adjusting the rows and columns, and center-align your text.
This is now what your column headers look like. The report is now more compact and put together 😊
Or try another orientation option like the Rotate Text Up.
Try other options too like the angle clockwise, vertical text, or rotate-down.
If you want to align the text to a particular angle and add additional customizations, you can orient them using the Format Cells option 😀
More settings: Choose a specific text direction
The Format Cells option is another way to rotate text in your cells. You can access more settings to customize the text orientation as you want.
There are three (3) ways to access the Format cells option to rotate text in Excel.
- Right-clicking the selected cells and choosing Format Cells from the menu
- Clicking Format Cell Alignment from the Orientation option drop-down
- Clicking the Alignment Settings dialog box launcher
Any of the three will launch the Format cells dialog box 👍
Let’s use the Format cell alignment from the Orientation for this tutorial.
- Select the cells you want to rotate.
- Go to the Home Tab.
- In the Alignment group, click the Orientation icon.
- Click the Format Cell Alignment option at the bottom.
The Format cells dialog box will pop up on your screen.
In the dialog box, under the Alignment tab, you can see a dial-shaped feature in the orientation to the right.
You’ll see the current orientation of the text in the selected cells.
- To rotate the text to a precise angle, you can either enter an exact number of degrees you want to rotate the text to or drag the dial to set the degree of rotation of the text.
As you drag the dial, the angle automatically adjusts. This way you can know and set the degree of rotation for the text 😊
Let’s set the orientation to 70 degrees.
- Finally, click OK.
The text is now rotated to a specific number of degrees.
When you compare the before and after look of the data table, it shows a great difference 🤩
Keyboard shortcut to rotate text
If rotating text is something that you need to do often, then knowing the shortcut to do this could save you some time ⏰
The keyboard shortcut to rotate text is Alt + H + F + Q + O (press keys one after another).
- Select the text you want to rotate.
- Press Alt + H. This opens the Home Tab and highlights the keyboard shortcut keys to every button and option in the Home Tab.
- The shortcut key for the Orientation button is FQ. Press F and then Q.
Here, you’ll see the orientation dropdown showing up with the shortcut keys for each type of rotation 👀
If you want to rotate the text in a specific orientation…
- Press the keys appropriate for it.
It may be a long keyboard shortcut but it is the fastest way ⚡ to rotate the text in your cells, especially when you are more comfortable doing work in Excel with your keyboard than your mouse 😊
That’s it – Now what?
Way to go! 👏 Now you’ve learned how to rotate text in Excel to help you improve the overall look of your data tables and report. It may be a simple move but it can help you save up space, highlight important content, and give your spreadsheets a little touch of style 😊
It’s amazing how Microsoft Excel enables you to do all of these things! But we’re only talking about the basic things Excel can do for you 🤯
Learn more about how you can effectively clean your data in Excel so you can focus on data that matters! Aside from that, you’ll learn advanced functions you wish you knew sooner when working in Excel when you sign up for my free course.
Sign up for my free Excel Intermediate training ✍ and turbocharge your Excel skills 🚀
Don’t know what to learn next? We got you! Here are the best-related tutorials we suggest you read next 💡
- How to Insert Multiple Rows in Excel (and Single Rows too!)
- How to Highlight Every Other Row in Excel: Step-by-Step (2023)
- How to Select Multiple Cells in Excel – Fast and Easy (2023)
Need help in Excel? Contact us here.