Yes. In Excel for Microsoft 365 on Windows, select the cell or cells, then choose Home > Alignment > Orientation and pick a direction. For a specific angle, open Format Cells > Alignment and set Orientation from -90 to 90 degrees.
What rotating text in Excel changes
Text rotation is a cell-formatting option. It changes how the contents appear inside a worksheet cell, not the contents themselves. A heading such as Monthly total remains the same text for formulas, searches, sorting, and copying, even if it is displayed diagonally or vertically. Click the cell and the original value is still visible in the formula bar.
This makes rotation useful when the information is correct but the layout is crowded. For example, a table with twelve narrow month columns may be easier to read if the month names are turned on an angle rather than shortened to Jan, Feb, and so on. Rotated labels can also make a compact report or printout fit more naturally across a page.
Rotation is not the same as changing the text direction for a whole worksheet, nor does it rotate the worksheet grid. It applies to selected cells. If a cell contains a number or date, Excel can display that value at an angle too, while retaining its underlying value and number format.
How to rotate text with the ribbon
For the standard options in Excel for Microsoft 365 on Windows, use the Orientation menu on the Home tab:
- Select one cell or a range. To format several labels together, select all of their cells before opening the menu.
- Choose Home > Alignment > Orientation. The control is in the Alignment group and may appear as a slanted ab icon.
- Select the desired option, such as Angle Counterclockwise, Angle Clockwise, Vertical Text, Rotate Text Up, or Rotate Text Down.
- Review the row heights and column widths. Adjust them if the result is clipped or takes up more space than expected.
The menu applies a preset rather than requiring you to enter a number. If the label looks tilted in the wrong direction, reopen Orientation and try the opposite angle option. You can also use Format Cells for finer control, described below.
To remove the rotation, select the affected cells and choose Home > Alignment > Orientation > Format Cell Alignment. In the dialog, set Orientation back to 0 degrees. Some Excel builds also offer a horizontal or no-rotation choice directly in the Orientation menu.
What the Orientation options mean
The menu contains options that may look similar but produce different layouts. Choosing the right one avoids turning a simple heading into something difficult to read.
- Angle Counterclockwise and Angle Clockwise: Slant the text diagonally. These are often useful for narrow column headings, such as product names or dates.
- Vertical Text: Stacks the characters vertically instead of rotating the whole line as a single unit. It can work for short labels, but is usually harder to read for long English words or sentences.
- Rotate Text Up and Rotate Text Down: Turn the line of text so it reads vertically in one direction or the other. This differs from stacking characters one below another.
- Format Cell Alignment: Opens the full formatting dialog, where you can set an exact angle and change other alignment settings.
For a column heading that should remain legible, a modest diagonal angle is often a better starting point than a full 90-degree turn. For a very narrow column containing a one-word label, vertical text may save width, but test it with the actual font and row height. The best choice depends on the length of the text and whether readers need to scan across many columns.
Set an exact rotation angle
To enter a custom angle in Windows Excel, select the cells and open Format Cells. You can right-click the selection and choose Format Cells, or press Ctrl+1. Open the Alignment tab, then use the Orientation control. Enter a number or adjust the dial, and confirm with OK. The available range is -90 to 90 degrees, with 0 degrees representing normal horizontal text.
A value near 45 degrees produces a diagonal label; values near either end of the range make the text close to vertical. The sign determines which way the text tilts. If you are unsure which direction suits your table, try a small angle first, then reopen the dialog and adjust it. The displayed result can also depend on the cell dimensions, so an angle that works in a wide cell may look cramped in a narrow one.
On Excel for Mac, select the cells and use the Orientation control on the Home tab, or open Format Cells and look for the Alignment settings. Command+1 opens Format Cells on many Mac keyboards; shortcuts can vary with keyboard layout and system settings. Excel for the web provides cell text-orientation controls on the Home tab, but the available interface and fine-grained options can differ from desktop Excel. If you need a particular angle and cannot find the setting in the web interface, open the workbook in the desktop app.
Make rotated headings fit the worksheet
Rotation changes the space a label needs in both directions. A long label angled upward may need extra row height even though it occupies less horizontal width. A vertical label can make its row taller, while a narrow column can still truncate the text if the displayed area is insufficient. Inspect the whole range after applying the format rather than judging from one cell.
Try these layout adjustments when the text does not look right:
- Widen or narrow the column to balance the label width against the data below it.
- Increase the row height if the tops or bottoms of letters are cut off.
- Use Home > Format options to adjust row height or column width, or drag the boundary between row or column headings.
- Consider Wrap Text for multiword labels that should stay horizontal, or shorten a heading if that preserves clarity.
- Check horizontal and vertical alignment in Format Cells > Alignment so the rotated text sits where readers expect.
Merged cells deserve special attention. AutoFit does not always size merged areas as expected, and rotation can make a merged heading harder to position. If a label is clipped in merged cells, set the row height or column width manually, or consider unmerging the cells and using another alignment approach. Before printing, use Print Preview because page scaling and margins can make a layout look different from the worksheet view.
When rotated text is useful—and when it is not
Rotation is most useful for short labels in dense tables: months, abbreviations, category names, or compact headings above narrow columns. It can reduce the width a heading consumes and let more columns fit on screen or on a printed page. It is also handy for distinguishing a small number of header cells without changing the data layout.
It is less suitable for long instructions, full sentences, or important values that readers must compare quickly. Angled text takes more effort to scan, and vertical text may be difficult for people using screen magnification or reading a printout. For long labels, consider widening the column, wrapping the text, abbreviating carefully, or moving the explanation into a note or separate header row. If a reader needs to understand a chart label, axis title, or decorative heading, a text box may offer more layout freedom than a cell.
For example, a sales report with columns for twelve months might use a 45-degree angle for month headings, while keeping the sales figures horizontal. A task tracker with only three wide columns gains little from rotating its headers; ordinary text is easier to read. Choose rotation to solve a real space problem, not simply because the option is available.
Rotation compared with other formatting and export
Text rotation is different from Wrap Text. Wrapping keeps characters in their normal orientation and places words on multiple lines within a cell. Rotation turns or stacks the displayed text. Both are alignment-related formatting choices, and they can affect the dimensions needed for a readable row or column.
It is also different from rotating a shape. If you need a label placed freely over the worksheet, insert a text box and rotate the object instead; that object is not the same as cell content and may not move or print like a cell value when the sheet changes. For ordinary table headings, cell rotation keeps the label attached to its cell, which is usually more convenient when sorting or resizing the table.
Formatting may not carry into every export format. A workbook saved as an Excel file retains cell formatting, but formats such as CSV store plain data rather than Excel’s visual cell layout. If another person needs to see the angled labels, share the workbook or a PDF/printout rather than assuming a plain-text export will preserve the appearance. The text itself remains available in the cell regardless of its displayed angle.
Common problems and fixes
If the Orientation command appears unavailable, first check that you have selected worksheet cells and are not editing the contents of a cell. Press Esc or Enter to leave edit mode, select the range again, and reopen the Home tab. A protected worksheet may also restrict formatting; if you have permission, use Review > Unprotect Sheet before changing the format.
If only some labels rotate, check whether the selection included every intended cell. If the text looks reversed or leans the wrong way, reopen Orientation and choose another preset, or use the angle control in Format Cells. If letters are cut off, adjust row height or column width and inspect merged cells. If the sheet looks fine on screen but not on paper, check Print Preview, page orientation, margins, and scaling rather than assuming the cell text setting failed.
Finally, remember that changing orientation does not change how Excel interprets a value. A date remains a date, and a number remains a number. Rotation is a display choice, so it will not fix an incorrect date format, an overly long underlying value, or a formula error.
Frequently Asked Questions
Can I rotate text in Excel by 90 degrees?
Yes. Select the cells and choose an appropriate vertical rotation preset from Home > Alignment > Orientation, or set the angle near 90 or -90 degrees in Format Cells > Alignment. Use Vertical Text only if you want characters stacked rather than the entire line turned.
Can I rotate only one cell?
Yes. Select that cell alone and apply an Orientation option. You can also select a range to apply the same angle to multiple cells at once.
Can I rotate text diagonally in Excel?
Yes. Choose Angle Counterclockwise or Angle Clockwise for a preset diagonal, or enter a custom angle in Format Cells > Alignment. Adjust the row height or column width if the label becomes clipped.
Does rotating text change the cell value?
No. Rotation changes the cell’s appearance, not its stored text, number, date, or formula. The original contents remain available in the formula bar and to calculations.
Why can’t I rotate text in Excel?
Make sure you are not currently editing the cell and that the worksheet is not protected against formatting changes. In Excel for the web or on a different device, the control may be in a different place or offer fewer settings; try the desktop app for the full Format Cells dialog.
Related
- Can Power Automate Refresh Excel Power Query?
- Align Images in Excel: Steps, Options, and Common Fixes
- Can Excel Compare Means With a T-Test? Steps and Choices
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Data Run Analysis: A Practical Runs TestExcel data run analysis checks whether values in a sequence appear in a meaningful order or are consistent…
- Excel Data to Word: Choose the Best Way to Transfer ItTo put Excel data in Word, select the cells in Excel, press Ctrl+C, click where the data should…
- Excel Remove Duplicates: Keep the Last Matching RecordExcel’s Remove Duplicates command keeps the first matching row it encounters; it has no built-in option to keep…
- Open Excel Files in Google Sheets: A Step-by-Step GuideTo open an Excel workbook in Google Sheets, upload the .xlsx or .xls file to Google Drive, then…
- How to Delete a Blank Page in Word: Step-by-StepTo delete a blank page in Microsoft Word, turn on formatting marks, find the paragraph mark, page break,…
- Protect Sheet in Excel: Allow Editing Specific CellsYes. In Excel for Microsoft 365 on Windows, you can protect a worksheet and still allow editing in…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.