Skip to main content
  • Login
Cart
Exceljet logo Exceljet
  • Training
  • Videos
  • Functions
  • Formulas
  • Shortcuts
  • Articles
Cart
  • Login
  • Training
  • Videos
  • Functions
  • Formulas
  • Shortcuts
  • Articles
  • Login

You are here

Home › Videos › How to use text orientation in Excel

How to use text orientation in Excel

Transcript 

In this lesson we'll look at how to use text orientation. Orientation allows you to rotate text in a variety of ways.

Let's take a look.

Here we have a simple feature summary table. We can use orientation to spice things up a bit.

Before we do that, however, let's look at what types of orientation are available. Orientation options are in a menu in the Alignment group on the home tab of the ribbon.

There are two basic types of orientation. One type stacks letters on top of one another. This is called Vertical Text in the orientation menu. Vertical Text is either on or off.

In the Format Cells dialog box, Vertical text is the option on the left of the orientation group. Be aware that if you set the Vertical text option from the Format Cells dialog box, Excel will switch Vertical alignment to Bottom alignment with an indent. You can use the indent, or switch Vertical alignment back to Center.

The other type of orientation is rotated. Excel allows you to rotate text up to 90 degrees both clockwise and counterclockwise. There are four fixed settings in the orientation menu for common options.

The last item in the menu brings you into the Format Cells dialog box, where you can make finer grained changes. For example, you can choose an angle other than 45 degrees.

Now let's look at our main table. One common use of rotated text is for column headers. We can select all the headers we want to rotate and apply rotation in one step.

Another possibility for this kind of table is to change the orientation of the categories in column B. We could use Vertical Text. But in general, text rotated 90 degrees counterclockwise will create a cleaner look.

To remove text orientation, just select the cells and select the orientation option again to "toggle" orientation off. You can also visit the Format Cells dialog box and set Degrees to zero.

Master Excel with practice. Download this worksheet (and dozens more) in our Core Excel course. Learn by doing.

Dave Bruns Profile Picture

Author

Dave Bruns

Hi - I'm Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.

Microsoft Most Valuable Professional Award  

Exceljet Training

  • Excel 101
  • Excel Fundamentals
  • Conditional Formatting
  • Essential Formulas
  • Advanced Formulas
  • Pivot Tables
  • Excel Tables
  • Excel Shortcuts
  • Excel Charts
  • Course Bundles
Thank you for including transcripts of your videos! I happen to be someone who works better from written instructions with pictures/screenshots than from videos, so I really appreciate this.
Sarah
More Testimonials

Get Training

Quick, clean, and to the point training

Learn Excel with high quality video training. Our videos are quick, clean, and to the point, so you can learn Excel in less time, and easily review key topics when needed. Each video comes with its own practice worksheet.

View Paid Training & Bundles
Excel foundational video course
Excel Pivot Table video training course
Excel formulas and functions video training course
Excel Charts video training course
Video training for Excel Tables
Dynamic Array Formulas
Exceljet logo Exceljet
Quick, clean, and to the point

Resources

  • Training
  • Videos
  • Functions
  • Formulas
  • Shortcuts
  • Articles

About Us

  • About
  • Testimonials
  • Topics
  • Contact
  • Donate

Newsletter Sign-up

Work faster in Excel. Join more than 100,000 people who get weekly tips from us.
© 2012-2025 Exceljet. Terms of use
  • Visit our Twitter page