Rotate Text in Excel for Angled or Vertical Headers

To rotate text in Excel, select the cells and use Home > Orientation, or open Format Cells to set an exact angle. Rotated headers are the classic fix for a wide table with short numbers underneath and long column names on top. This guide covers both methods on Windows and Mac, when angled or vertical headers help, and the small layout problems that come with them.

Why rotate text in Excel?#

Rotating header text lets you make columns narrow without hiding long labels. Picture a training tracker: each column holds a short value like "Yes" or a number, but the headers say "Training completed" or "Overtime hours". With normal headers, every column has to be as wide as its longest label. With angled headers, the label runs diagonally above the column, and the column can shrink to fit the data.

Rotation is only formatting. The cell still contains the same text, so formulas, sorting, filters and lookups work exactly as before.

How to rotate text with the Orientation button#

The Orientation button is the fastest way to rotate text. It sits in the Alignment group of the Home tab and shows the letters "ab" with a slanted arrow.

1. Select the header cells, for example B1:F1.
2. Go to Home > Orientation.
3. Pick one of the options in the table below.

On Windows you can reach the menu from the keyboard: press Alt, then H, F, Q. The Orientation button is in the same place on the Home tab in Excel for Mac. The formatting shortcuts lesson covers more keyboard formatting like this.

How to set an exact angle in Format Cells#

Format Cells lets you choose any angle from -90 to 90 degrees, which is useful when 45 looks too steep.

1. Select the cells.
2. Press Ctrl+1 (Windows) or ⌘1 (Mac), or right-click and choose Format Cells.
3. Open the Alignment tab.
4. Under Orientation, drag the red diamond, or type a number in the Degrees box. Positive numbers tilt up, negative numbers tilt down.
5. Click the tall Text box on the left for stacked vertical text.
6. Click OK.

Angles of 30 to 60 degrees are easiest to read. A full 90 degrees saves the most width but makes readers tilt their head.

Angled vs vertical text: which should you use?#

Use angled text for most header rows, and vertical or 90-degree text only when space is very tight. Here's how they compare:

If your labels are long but you only have a few columns, rotation may not be the right fix. Wrapping text onto several lines often reads better, and AutoFit column width sizes columns to their content.

Fix the row height and borders after rotating#

Excel usually makes the row taller to fit rotated text, but you may need to adjust it. If the header row looks cut off, double-click the boundary under the row number to AutoFit the height, or drag it taller by hand.

Two more things change when you rotate:

• Column width. Now you can make the columns narrower. Select them and drag one boundary, and all selected columns take the same width.
• Borders. On angled cells, Excel slants the side borders to follow the text, which gives the familiar "slanted header" look. If you prefer straight lines, remove the side borders from the header row. See how to add and remove borders.

Avoid merging header cells you plan to rotate. Merged cells make sorting and selecting harder; the article on Merge & Center and its alternatives explains a safer option.

How to undo text rotation#

To remove rotation, select the cells and click the active option under Home > Orientation again; it toggles off. Or open Format Cells, go to Alignment and set Degrees to 0. Clearing all formatting also removes it (Home > Clear > Clear Formats), but that strips number formats, fonts and fills too, so use it with care. The more formatting lesson shows how to reset a cell back to General.

When rotation won't work#

A few situations block or limit rotation:

• The sheet is protected. Formatting is off until you unprotect it (Review > Unprotect Sheet), unless the protection allows formatting cells.
• You are editing a cell. If the cursor is blinking inside a cell, most ribbon buttons are disabled. Press Esc or Enter first.
• You want 180 degrees. Cell text only goes from -90 to 90. For upside-down or free rotation, use a text box or shape and drag its rotation handle.
• Chart labels. Chart axis labels are rotated from the chart's own format pane (select the axis, then Format Axis > Size & Properties), not from the Home tab.

Pick the right width before you rotate#

Knowing the length of your longest header helps you decide whether to rotate at all. LEN counts the characters in a cell, and MAX picks the biggest:

=MAX(LEN(A1:E1))

For headers Employee, Mon, Overtime hours, Training completed and Site, the result is 18 ("Training completed"). If the longest header is much longer than the data below it, rotating is a good idea. In Microsoft 365 and Excel 2021 this formula works as typed; in older versions, confirm it with Ctrl+Shift+Enter. While you're tidying headers, it's also worth checking your number formats for currency and percentages.

Practise it#

Formatting sticks when your hands learn it. Practise formatting shortcuts in a live spreadsheet: you bold headers and apply number formats from the keyboard, and each step is checked instantly. Then try the more formatting lesson, and do the exercise on this page to measure your headers before you rotate them.