Cellwise Start free

Excel guide · 5 min read

How to rotate text in Excel

Quick answerSelect the cells, then go to Home > Orientation (the angled ab button in the Alignment group) and pick Angle Counterclockwise, Angle Clockwise, Vertical Text, Rotate Text Up or Rotate Text Down. For an exact angle, choose Format Cell Alignment from the same menu and type a number from -90 to 90 in the Degrees box. Positive numbers tilt the text up, negative numbers tilt it down.

Sample data

Every result on this page was calculated from this sheet by the same spreadsheet engine the Cellwise app uses.

RowABCDEFGH
1EmployeeFire safetyManual handlingFirst aid at workFood hygiene L2Data protectionWorking at heightDone
2Ana RuizYYNYYN4
3Ben OkaforYNNYYN3
4Chloe MartinYYYYYY6
5Dev PatelNYNNYY3
6Elena NovakYYYNNN3
7Femi AdeyemiYNNYYY4

Download this sheet as an Excel practice file (.xlsx)

Why rotate text: long headers over narrow data

The sample is a training matrix: six courses across the top, a Y or N for each employee. The data in every cell is one character, but the course names are long. Set the columns wide enough for the headers and the sheet sprawls off the screen; set them narrow and the headers get cut off or wrap into four lines.

Rotated headers fix the mismatch. The column can be as narrow as its data, and the header runs up and across instead of sideways.

=MAX(LEN(B1:G1))

Result: 17

17: the longest course name in characters (First aid at work). MAX(LEN(B2:G7)) on the data gives 1. That gap is the reason to angle the headers.

Rotate with Home > Orientation

The Orientation menu has five presets. Angle Counterclockwise (45 degrees up) is the classic angled header. Rotate Text Up turns it a full 90 degrees, reading bottom to top, which is the narrowest option. Vertical Text stacks the letters one above the other; it's readable for short words but makes long headers very tall.

  1. Select the header cells, here B1:H1.
  2. Go to Home > Orientation (the ab button with a slanted arrow, in the Alignment group).
  3. Choose Angle Counterclockwise.
  4. Select columns B:H and drag a column border narrower, or set a width with right-click > Column Width.
  5. To undo it, select the cells, open Orientation again and click the option that is highlighted, or set Degrees to 0.

Set an exact angle in Format Cells

The presets are 45 and 90 degrees. For anything else, such as a gentler 30-degree slope, use the Degrees box. You can also drag the red handle in the half-circle next to it.

  1. Select the cells and press Ctrl+1 (Cmd+1 on a Mac), or choose Home > Orientation > Format Cell Alignment.
  2. On the Alignment tab, find Orientation on the right.
  3. Type a number in the Degrees box: 30 tilts the text up, -30 tilts it down, 90 reads bottom to top.
  4. Click the tall Text box with letters stacked vertically if you want stacked text instead.
  5. Click OK.

Rows that grow too tall, wrap text and borders

Rotated text needs height instead of width, so Excel makes the row taller to fit it, as long as you haven't set the row height by hand. If the row is huge, the culprit is usually a long header: shorten it (Data protection instead of GDPR data protection training) or put a line break in it with Alt+Enter so it rotates as two shorter lines.

Wrap Text and rotation work together: a wrapped, rotated header keeps each line short, which keeps the row height down. If a rotated header looks cut off, check Wrap Text isn't fighting a fixed row height; double-click the row border under the row number to autofit it.

Borders on angled cells slant with the text, which gives the familiar parallelogram look of angled table headers. If the slanted lines look messy, remove the left and right borders from the header cells and keep only a bottom border.

Can I put a line break in a header with a formula?

Yes, if the header is built by a formula. CHAR(10) is the line break; turn on Wrap Text for it to show. For typed headers, Alt+Enter while editing does the same. More in join text with a line break.

=SUBSTITUTE(D1," ",CHAR(10))

Result: First aid at work

First, aid, at and work on four lines once Wrap Text is on. Rotated, that's four short lines instead of one long one.

Keep the data readable

Angled headers are for labels. Don't rotate the numbers or the Y/N cells themselves: people read down columns, and tilted data slows them down. Keep the summary column (Done) narrow but upright if it's what people look at first.

A narrow, rotated matrix fits on one printed page far more easily, which is often the real goal. After rotating, check Page Layout > Width: 1 page, and see print an Excel sheet on one page for the rest.

=COUNTIF(D2:D7,"Y")/COUNTA(D2:D7)

Result: 0.33333333333 shows as 33% with Percent format

0.33: a third of the team has done First aid at work. This is the kind of figure people want from the matrix, so give the data the space and the headers the angle.

Rotate text in Excel for the web, on a Mac, and in charts

Microsoft says Excel for the web doesn't have the text orientation option. Text you rotated in the desktop app should still display rotated in the browser, but to change it you need the desktop app (Editing > Open in Desktop App).

On a Mac the Orientation button is on the Home tab too, and Cmd+1 opens the same Alignment tab with the Degrees box.

Chart axis labels are a different setting. Right-click the axis, choose Format Axis, then look for the Alignment options under Size & Properties, where you can pick a text direction or a custom angle.

Common mistakes

Rotating long headers without shortening them

The row becomes very tall. Shorten the header or split it with Alt+Enter and Wrap Text.

Using Vertical Text for long words

Stacked letters are hard to read. Use Rotate Text Up (90 degrees) instead.

Rotating the data cells

Rotate the header row only, so people can still read down the columns.

A fixed row height that cuts off rotated text

Double-click the row border under the row number to autofit the height.

FAQ

How do I make text vertical in Excel?

Select the cells and choose Home > Orientation > Rotate Text Up for text that reads bottom to top, or Vertical Text for letters stacked one above the other.

How do I rotate text 90 degrees in Excel?

Home > Orientation > Rotate Text Up (90) or Rotate Text Down (-90). Or press Ctrl+1 and type 90 in the Degrees box on the Alignment tab.

How do I angle column headers in Excel?

Select the header row and choose Home > Orientation > Angle Counterclockwise, then make the columns narrower. Use Format Cells > Alignment > Degrees for an angle other than 45.

Why can't I rotate text in Excel?

You're probably in Excel for the web, which has no orientation option, or the cell is still being edited. Press Esc and use the desktop app.

How do I rotate text back to normal?

Select the cells, press Ctrl+1 and set Degrees to 0 on the Alignment tab.

Functions used

Related guides

Updated