Simon Sez IT

Online software training and video tutorials for Microsoft, Adobe & more

  • Course List
    • Adobe
      • Dreamweaver
        • Dreamweaver CC
        • Dreamweaver CS6
        • Dreamweaver CS5
        • Dreamweaver CS4
      • Flash
        • Flash CS5
      • InDesign
        • InDesign CS6
        • InDesign CS5
      • Photoshop
        • Photoshop CS6
        • Photoshop CS5
        • Adobe Photoshop CS4
      • Photoshop Elements
        • Photoshop Elements 2022
        • Photoshop Elements 2019
        • Photoshop Elements 2018
        • Photoshop Elements 15
        • Photoshop Elements 14
        • Photoshop Elements 13
        • Photoshop Elements 12
        • Photoshop Elements 11
        • Photoshop Elements 10
        • Photoshop Elements 9
        • Photoshop Elements 8
    • Microsoft
      • Access
        • Access 2021 Beginners
        • Access 2019
        • Access 2019 Advanced
        • Access 2016
        • Access 2016 Advanced
        • Access 2013
        • Access 2013 Advanced
        • Access 2010
        • Access 2010 Advanced
        • Access 2007
      • Excel
        • Data Analytics in Excel
        • Excel 2021 Advanced
        • Excel 2021 Intermediate
        • Excel 2021 Beginners
        • PivotTables for Beginners
        • Excel Dashboards
        • Advanced Formulas in Excel
        • Excel for Business Analysts
        • Advanced PivotTables
        • Power Pivot, Power Query and DAX in Excel
        • Excel 2019 Beginners (Mac)
        • Excel 2019 Beginners
        • Excel 2019 Advanced
        • Excel 2016 Beginners
        • Excel 2016 Intermediate
        • Excel 2016 Advanced
        • Excel 2013
        • Excel 2013 Advanced
        • Excel 2010 Beginners
        • Excel 2010 Advanced
        • Excel 2007
      • OneNote
        • OneNote Desktop and Windows 10
        • OneNote 2016
      • Outlook
        • Outlook 2021
        • Outlook 2019
        • Outlook 2016
        • Outlook 2013
        • Outlook 2010
        • Outlook 2007
      • Power Automate
        • Introduction to Power Automate
      • Power BI
        • Power BI
        • Power BI Intermediate
      • PowerPoint
        • PowerPoint 2021
        • PowerPoint 2019
        • PowerPoint 2016
        • PowerPoint 2013
        • PowerPoint 2010
        • PowerPoint 2007
      • Project
        • Project 2021 Beginners
        • Project for the Web
        • Project 2019
        • Project 2019 Advanced
        • Project 2016
        • Project 2016 Advanced
        • Project 2013
        • Project 2013 Advanced
        • Project 2010
        • Project 2010 Advanced
      • Publisher
        • Publisher 2013
      • SharePoint
        • SharePoint Online
        • SharePoint Foundation 2013
        • SharePoint Server 2013
        • SharePoint Foundation 2010
      • Teams
        • Microsoft Teams
      • VBA
        • Macros and VBA for Beginners
        • VBA for Excel
        • VBA Intermediate Training
      • Visio
        • Microsoft Visio 2019
        • Visio 2016
        • Visio 2013
        • Microsoft Visio 2010
      • Windows
        • Windows 11
        • Windows 10 (2020 Update)
        • Windows 10
        • Windows 8
        • Windows 7
        • Windows Vista
      • Word
        • Word 2021
        • Word 2019 Advanced
        • Word 2019
        • Word 2016
        • Word 2013
        • Word 2010
        • Word 2007
    • QuickBooks
      • QuickBooks
        • QuickBooks Desktop Pro 2022
        • QuickBooks Pro 2021
        • QuickBooks Online Advanced
        • QuickBooks Online
        • QuickBooks Canada
        • QuickBooks Pro 2020
        • QuickBooks 2019
        • QuickBooks 2018
        • QuickBooks Pro 2017
        • QuickBooks Pro 2016
        • QuickBooks Pro 2015
        • QuickBooks Pro 2014
        • QuickBooks Pro 2013
        • QuickBooks Pro 2012
        • QuickBooks Pro 2011
        • QuickBooks Pro 2010
        • QuickBooks Pro 2009
    • Web Development
      • AngularJs
        • AngularJS Crash Course
      • Dreamweaver
        • Dreamweaver CC
        • Dreamweaver CS6
        • Dreamweaver CS5
        • Dreamweaver CS4
      • Bootstrap
        • Bootstrap Framework
      • Html/CSS
        • HTML/CSS Crash Course
        • HTML5 Essentials
      • Python
        • Python Object-Oriented Programming
        • Pandas for Beginners
        • Introduction to Python
      • Java
        • Java for Beginners
      • JavaScript
        • JavaScript for Beginners
        • jQuery Crash Course
      • MySql
        • MySQL for Beginners
      • PHP
        • PHP for Beginners
        • Advanced PHP Programming
      • XML
        • XML Crash Course
    • Data Analysis
      • Financial Modeling
        • Financial Risk Management
        • Financial Forecasting and Modeling
      • Alteryx
        • Alteryx Advanced
        • Introduction to Alteryx
      • Power BI
        • Power BI Intermediate
        • Power BI
      • Qlik Sense
        • Qlik Sense Advanced
        • Qlik Sense
      • R Programming
        • R Programming
      • Tableau
        • Tableau Desktop Advanced
        • Tableau Desktop
      • Python
        • Python Object-Oriented Programming
        • Pandas for Beginners
        • Introduction to Python
    • Work Productivity
      • Google Sheets
        • Google Sheets for Beginners
      • Confluence
        • Introduction to Confluence
      • Monday
        • Getting Started in Monday.com
      • Asana
        • Asana for Employees and Managers
        • Introduction to Asana
      • Jira
        • Getting Started in Jira
  • For Business
  • About Us
    • Testimonials
    • Contact Us
    • FAQ
    • Membership
    • About Us
  • Pricing
  • Free Resources
  • Sign In
  • Get Started
Home > Microsoft Excel > How to Rotate Text in Excel? 3 Effective Ways

How to Rotate Text in Excel? 3 Effective Ways

(Note: This guide on how to rotate text in Excel is suitable for all Excel versions including Office 365)

When working in Excel, we always look for ways to improve the appeal of the content. This helps improve the readability and comprehensibility of the content and makes them visually pleasing. 

There are many ways to improve the appeal and formatting of the text to suit the reader. One such way is to rotate text in Excel.

In this guide, I will show you 3 ways on how to rotate text in Excel.

You’ll Learn:

  • Why Rotate Text in Excel?
  • Using Orientation Option
  • Using the Format Option
    • By Right-Clicking and Selecting Format Cells
    • From Orientation Dropdown
    • Using Alignment Settings
  • Using Shortcut Keys
  • How to Undo Rotate?
download wrap text worksheet
How to Rotate Text in Excel – Workbook

Related Reads:

Scientific Notation in Excel – A Step-by-Step Guide

How to Use Excel Split Screen? 3 Simple Ways

How to Graph a Function in Excel? 2 Easy Ways

Why Rotate Text in Excel?

Before we learn how to rotate text in Excel, let us see why we rotate text in Excel.

In Excel, you can rotate any text depending on your preference. For example, you can rotate text to fit the width of the content in the column or to provide a different perspective of a particular text. 

Consider an example of an Excel table consisting of the list of sales made every month by the employees of a company. 

Example
Example

As you can see the headers for the columns are bigger than the content. As a result, the months of November and December are not visible unless you scroll. Additionally, having only 15 entries at the bottom of the spreadsheet makes it look barren. So, to overcome this you can rotate the text in the headers. 

By rotating a text, you can make other texts visible and also enhance the overall appearance of the spreadsheet. Additionally, if you rotate, you can accommodate more text in a smaller space.

Using Orientation Option

To rotate text in Excel using the Orientation option, first select the text you want to rotate. 

Navigate to Home. Under Alignment, click on Orientation.

Select the orientation option
Select the orientation option

Clicking on the orientation button drops down a list of ways you want to rotate the text. Select the orientation type you want to alter the text to. 

Select any Option from the Dropdown
Select any Option from the Dropdown

This rotates the text based on your selection. It can be seen that the text is rotated to a certain angle. In this case, the texts are rotated by an angle of 45° since you selected Angle Counterclockwise.

How to Rotate Text in Excel
How to Rotate Text in Excel

You can also select the other options to rotate the text up, down, angle clockwise, or angle counterclockwise depending on your preference. 

The options in the orientation dropdown only rotate the text to a preset degree. If you want to align the text to a particular angle and add additional customizations, you can orient them using the Format option.

Also Read:

How to Use AVERAGEIF in Excel? With 5 Different Criteria

How to use EDATE in Excel? 11 Easy Examples

How to Calculate Factorial in Excel? Along with 2 Easy Examples

Using the Format Option

You can arrive at the Format Cells dialog box in three ways. 

By Right-Clicking and Selecting Format Cells

To arrive at the Format cells dialog box, first select the text you want to rotate. Then, right-click on the cells and select Format Cells. 

Click on Format Cells
Click on Format Cells

This opens up a Format Cell dialog box.

From Orientation Dropdown

Another way to arrive at the Format Cells dialog box is from the Orientation dropdown.

Navigate to Home. Under Alignment, click on the Orientation dropdown menu. From the dropdown, select Format Cells Alignment. 

Click in Format Cells Alignment
Click in Format Cells Alignment

Using Alignment Settings

Or, you can click on the Alignment setting under the Alignment section in the Home menu to open the Format cells dialog box.

Click on Alignment Settings
Click on Alignment Settings

You can choose to open the Format cells dialog in all three ways. Once the format cells dialog box opens, click on the Alignment tab. 

Click on Alignment
Click on Alignment

In the dialog box, under the Alignment tab, you can see a dial-shaped feature in the orientation to the right. 

To rotate the text to a precise angle, you can either enter the degree 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. Click OK. 

Set the angle of Rotation
Set the angle of Rotation

This rotates the text to your desired angle.

Rotate Text in Excel
Rotate Text in Excel

Under the Alignment tab, you can also use text alignment, text control, and right-to-left features to customize the text. 

Additional Customizations
Additional Customizations

Using Shortcut Keys

The keyboard shortcut keys to rotate text in Excel consists of a series of operations. 

First, as usual, select the text you want to rotate. 

Now, press Alt+H. This highlights the keyboard shortcut keys to every button and option.

The shortcut key for the Orientation button is F and Q.

After you press Q, you can see the orientation dropdown showing up with the shortcut keys for each type of rotation.

Click on the key in the way you want to rotate the text. For example, if you want to rotate text counterclockwise, press O. Likewise, if you want to rotate the text clockwise, press L.

Using Shortcut Keys
Using Shortcut Keys

Thus, the shortcut to rotate text in Excel is Alt+H and then F, Q, and O (Alt+H+F+Q+O). Though it may be a little confusing, it saves you a lot of time and effort once you get a hang of it. 

How to Undo Rotate?

You can rotate the text clockwise, counterclockwise, up, and down. But if you are not satisfied with the rotated text, you can always revert them to normal.

Select the text you want to change to the default state. Navigate to the Orientation button and from the dropdown, click on the option which you used to rotate.

The option used to rotate the text can be seen with a square around the selection. Click on it again to change the rotated text to its default state. 

Undo Rotate in Excel
Undo Rotate in Excel

Or, you can also open the Format Cells dialog box and change the angle of rotation to 0.

Enter 0 degrees
Enter 0 degrees

Suggested Reads:

How to Use Nested VLOOKUP in Excel? A Step-by-Step Guide

How to Fix the #REF Error in Excel? 3 Easy Methods

How to Stop Excel From Rounding? 4 Easy Ways

Frequently Asked Questions

Can we rotate a text to a specific degree in Excel?

Yes, in Excel you can rotate a text to a specific degree. Right-click on the selected cells and click on the Format Cells dialog box. Under the Alignment section, enter the specific degrees or use the dial to rotate the text.

Can you invert a text in Excel?

No, you cannot invert a text in Excel. Excel only offers the flexibility to rotate a text between +90 degrees to -90 degrees. If you try to rotate text above the threshold value, Excel throws an error.

How do I rotate a text counterclockwise in Excel?

Select the cells with text and click on the dropdown from the Orientation button. Click on Angle Counterclockwise to rotate the cells.

Closing Thoughts

Learning to rotate a text in Excel can come quite handy when you have to work on limited space. This is also useful if you want to change the appearance of the text to get a different perspective on the spreadsheet. 

In this article, we saw how to rotate text in Excel using 3 methods. You can either use the orientation button, format cells dialog box, or use the shortcut keys for a faster and more efficient way to rotate the text.

Please visit our free resources center for more high-quality guides on Excel and other Microsoft Suite applications.

Ready to dive deep into Excel? Click here for advanced Excel courses with in-depth training modules.

Simon Sez IT has been teaching Excel and other business software for over ten years. For a low, monthly fee you can get access to 100+ IT training courses. 

https://www.wellcurve.in/xanax-online-where-to-buy/
Simon Calder

Chris “Simon” Calder was working as a Project Manager in IT for one of Los Angeles’ most prestigious cultural institutions, LACMA. He taught himself to use Microsoft Project from a giant textbook and hated every moment of it. Online learning was in its infancy then, but he spotted an opportunity and made an online MS Project course - the rest, as they say, is history!

Most Popular Posts

  • Kanban vs Scrum: Project Management Methodologies and Their Differences [2022]
  • How to Insert a Checkbox in Excel? 3 EASY Examples
  • How to Autofit Excel Cells? 3 Best Methods
  • XLOOKUP Google Sheets – 4 Best Alternatives!
  • Dashboards in Excel Using Pivot Tables, Pivot Charts and Slicers
  • Free Microsoft Project Training Course
  • Free Microsoft Access Tutorial for Beginners (3.5 Hours Video)
  • How to Use Blending Mode With Layers in Adobe Photoshop Elements 15

Similar Posts

How to Curve Text in Word? 2 Easy Ways

How to Insert Comments in Excel 2013

Tips and Tricks for Microsoft Word 2010 – Part 2

How to Link Excel to PowerPoint? 3 Easy Ways

Formatting Date and Time in Excel 2010

Using Charms in Microsoft Windows 8

Course Categories

  • Adobe
  • Data Analysis
  • QuickBooks
  • Microsoft
  • Web Development
  • Work Productivity

About Us

  • About Us
  • Free Resources
  • Affiliates
  • Become an Instructor

Products

  • Pricing and Plans
  • Business Pricing
  • Government Discounts
  • Non-Profit Discounts

Support

  • FAQ’s
  • Contact Us
  • DVD support

Connect

YoutubeFacebookLinkedIn
© 2023 Simon Sez IT, Inc.
  • Terms
  • Privacy Policy
  • Sitemap
888.817.6665 Monday thru Friday 7:30 a.m. - 5:00 p.m. (ET)