Question EN

How do I change text direction in an Excel cell?

Answer

Select the cell, on the Home tab click the 'Orientation' button (ab with an angled arrow) and choose your angle or vertical text.

Detailed explanation

Rotating text helps fit long headers into narrow columns.

Quick Method

Select the cells
Home tab
Click the Orientation button (ab with arrow)
Choose: angle up, angle down, vertical text

Setting a Precise Angle

Select the cells
Ctrl+1 (Format Cells)
Alignment tab
In the Orientation section, set an angle from -90° to 90°

Popular Options

45° — for table headers (balance between readability and compactness)
90° — vertical text bottom to top
-90° — vertical text top to bottom
Vertical text — each letter stacked below the previous

Tip

After rotating, adjust column width and row height for optimal display.

02.02.2026 Excel / Google Sheets

Need a custom formula?

Describe your task — AI will generate a working formula in seconds

Generate Formula

Related Questions

How do I calculate a percentage in Excel?

Multiply the number by the percentage and divide by 100. For example, =A1*15/100 or simply =A1*15% — Excel understands both.

How do I round numbers in Excel?

Use the ROUND function: ROUND(number, decimals). For example, =ROUND(3.14159, 2) returns 3.14. For rounding up use ROUNDUP, for down use ROUNDDOWN.

How do I calculate an average in Excel?

The AVERAGE function calculates the arithmetic mean. For example, =AVERAGE(A1:A10) computes the average of a 10-cell range.

How do I raise a number to a power in Excel?

Use the ^ operator or the POWER function. For example, =2^3 or =POWER(2,3) — both return 8 (two cubed).

How do I get the absolute value in Excel?

The ABS function returns the absolute value of a number. For example, =ABS(-15) returns 15, and =ABS(15) also returns 15.

Great formula!

Sign in to save formulas and get more free requests

Sign in for free