To rotate text in Microsoft Excel, select the cell or cells, then choose Home > Orientation and pick a direction. For a specific angle, open Format Cells > Alignment and set the Orientation value. Rotating text changes how it appears inside the cells; it does not change the underlying text or rotate the worksheet.
Angled or vertical labels can make narrow columns easier to read, help headings fit across a compact table, or draw attention to a particular field. Before changing orientation, decide whether you want the entire text line tilted or its letters arranged vertically; Excel provides different options for those effects.
What You’ll Need
- A workbook you can edit in Microsoft Excel. These instructions are for Microsoft 365 on Windows.
- The cell or range whose text you want to rotate. You can select a blank cell first and type into it later, too.
- Excel for Mac or Excel for the web, if you are using one of those versions. The main orientation controls are similar, but some dialog options and shortcuts differ.
Step-by-Step
- Select the cell or range. Click a cell to rotate one label. To apply the same orientation to several labels, select the entire range first: click and drag across neighboring cells, or click the first cell, hold Shift, and click the last. For separate, nonadjacent cells in Windows, hold Ctrl while selecting each one. Check the highlighted range before continuing, because the orientation command affects every selected cell.
- Open the Orientation menu. Go to the Home tab and find the Alignment group on the ribbon. Choose Orientation, shown with a slanted text icon. If the ribbon is narrow, Excel may compress the group; maximize the window or expand the Alignment controls to find the command. The button opens a list of ready-made directions.
- Choose a preset that matches your goal. Angle Counterclockwise and Angle Clockwise tilt the text line diagonally. Rotate Text Up or Rotate Text Down turns the line so it reads vertically in one direction or the other. Vertical Text arranges the characters from top to bottom rather than turning the whole line as a unit. Click a choice and inspect the cell. If it is not the direction you want, reopen the menu and choose another option.
- Set an exact angle if needed. Select the target cells and press Ctrl+1 on Windows to open the Format Cells dialog. Choose the Alignment tab, then use the Orientation control. Enter a degree value or drag the orientation indicator, and select OK. Values range from -90 to 90 degrees; 0 returns the text to its normal horizontal position. Try a modest angle first, such as 30 or 45 degrees, because steep angles can take up more space.
- Adjust alignment and wrapping. Rotated text may look cramped even when the angle is correct. On the Home tab, use the horizontal and vertical alignment buttons in the Alignment group to place the text where it is easiest to read. You can also use Wrap Text when you want longer content to occupy more than one line within a cell. Wrapping and rotation affect layout, so check the result rather than assuming one setting will automatically solve every fit issue.
- Resize rows or columns if necessary. Drag a row boundary or column boundary in the worksheet headers to change its size. To fit a column to its contents, double-click the boundary on the right side of its column letter; for a row, double-click the boundary below its row number. AutoFit can produce a much wider column than you want, so a manual width or height may be better for a compact heading layout. Rotated or wrapped text can also affect the row height Excel needs to display the content.
- Review the full range. Look at every selected cell, not just the first one. Confirm that words are readable, do not overlap neighboring content, and are not cut off. If the range is part of a formatted table, check the headings and any filters or adjacent labels. Use Undo with Ctrl+Z if the latest change is wrong, then reselect the cells and try a different preset or angle.
- Save and check the output that matters. Save the workbook after the layout looks right. If the sheet will be printed or exported to PDF, use Print Preview as well: page scaling, margins, and column widths can make a readable worksheet look crowded on paper. Text orientation changes cell presentation; it is not the same as changing page orientation in the print settings.
On a Mac, select the cells and use Home > Orientation for the presets. Command+1 usually opens Format Cells; if that shortcut is unavailable on your keyboard or in your Excel setup, open the Format Cells dialog from the ribbon or menu and choose Alignment. In Excel for the web, use the Home tab’s Orientation control when it is available. If you need a precise custom angle and cannot find the full Orientation control, open the workbook in the desktop app.
Common Mistakes
- Choosing Vertical Text when you mean a rotated line. Vertical Text places characters in a top-to-bottom arrangement. If you want a word turned on its side, use Rotate Text Up or Rotate Text Down, or set a custom angle in Format Cells.
- Changing the wrong cells. A selection can include more cells than expected, especially after selecting a whole row or column. Check the highlighted cells before clicking Orientation. If only one label should change, select only that cell.
- Assuming rotation fixes every overflow problem. Rotating a long heading may reduce its horizontal footprint, but it can increase the required row height or make the heading harder to scan. Consider a shorter label, a wider column, or wrapping text instead.
- Confusing text rotation with page orientation. The Orientation command in the Alignment group rotates cell text. Page Layout controls such as page orientation change how a printed page is laid out, not the direction of text inside a cell.
- Using an extreme angle without checking readability. A near-vertical heading can be difficult to read and may require extra space. Start with a preset or a smaller custom angle, then inspect the worksheet at normal zoom.
Tips
- Keep heading styles consistent. If multiple column headings need the same treatment, select them together and apply one preset or angle. Consistency helps readers compare columns without repeatedly adjusting their reading direction.
- Use rotation selectively. A few angled headings can save horizontal space in a dense table. Rotating every label, value, and note can make the sheet harder to scan. Keep data cells horizontal unless there is a clear reason to change them.
- Pair a modest angle with alignment. A diagonal heading can look uneven if it sits too close to a cell edge. Adjust horizontal or vertical alignment, then tune the row height and column width. Small layout changes often help more than making the angle steeper.
- Use a short label where possible. Text rotation is most useful for concise headings such as Month, Status, or Region. For a long description, shorten the heading if the meaning remains clear, or use wrapping in a wider cell rather than forcing the full phrase into a narrow column.
- Preserve a readable structure. Keep rotated headings in a single header row when possible, and leave enough space between the header and the data. If you use merged cells, check the result carefully; merged ranges can make selection, alignment, and sizing less straightforward.
- Remember that appearance is not content. Rotation does not rearrange the words, alter formulas, or change the stored value. Sorting, searching, and referencing the cell continue to use its original contents.
Troubleshooting
The text did not rotate. Confirm that you selected a cell containing text and used Home > Orientation, rather than a page setup command. If the text appears unchanged, check whether the selected cell is part of a merged range or whether your selection was different from what you intended. Try the command on one ordinary cell to narrow down the cause.
The text is cut off or the row looks too short. Increase the row height or column width by dragging the worksheet headers. You can also try AutoFit by double-clicking the relevant row or column boundary. If the result becomes too large, undo AutoFit and set a more suitable size manually. Check Wrap Text if a long label needs multiple lines.
The direction is backwards or the letters are stacked. Open the Orientation menu again and choose the opposite direction, such as Rotate Text Up instead of Rotate Text Down. If individual characters are arranged vertically, switch from Vertical Text to a rotation option. For a particular diagonal direction, use Format Cells > Alignment and adjust the angle.
You cannot enter a custom degree value. Use the desktop version of Excel and open Format Cells with Ctrl+1 on Windows, then select Alignment. In Excel for the web, the available controls can differ; open the workbook in the desktop app if the custom Orientation field is missing. On Mac, use Command+1 or open the Format Cells dialog through the available menu or ribbon command.
The worksheet looks fine but the printout does not. Open Print Preview and check the page size, margins, scaling, and print area. A rotated heading may fit on screen but force a page to scale down or break across pages. Adjust column widths or print layout settings separately; changing cell text orientation alone does not change the page’s portrait or landscape setting.
Frequently Asked Questions
Can I rotate text to any angle in Excel?
In desktop Excel, the Format Cells dialog lets you set an orientation from -90 to 90 degrees. The ready-made Orientation menu is quicker for common directions. Excel for the web may not offer the same custom-angle controls, so use the desktop app if you need an exact value.
How do I make text read vertically without turning the whole word?
Select the cell, choose Home > Orientation > Vertical Text, and check the result. This arranges the characters vertically. For a word turned as a single line, choose Rotate Text Up or Rotate Text Down instead.
Can I rotate text in several cells at once?
Yes. Select the range first, then choose an Orientation preset or set an angle in Format Cells. The same setting is applied to each selected cell. To avoid changing unrelated cells, inspect the selection before applying the command.
Does rotating text change the cell value?
No. Rotation is a display and alignment setting. The text remains the same for editing, searching, formulas, and other workbook operations.
Can I rotate text in Excel for the web?
Excel for the web includes text-orientation options in the Home tab when supported by the current interface, but its controls may differ from desktop Excel. Open the workbook in the desktop app for the full Format Cells dialog and custom-angle adjustments.
Related
- Print Excel on One Page: Fit a Worksheet to Paper Size
- Paste Transpose in Excel: Shortcut and Steps
- Print an Excel Column on Every Page: Step-by-Step
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Apply Data Validation to an Entire Excel ColumnIn Excel for Microsoft 365 on Windows, select the column by clicking its letter, then choose Data >…
- How to Keep the Top Row Visible on Every Excel Print PageTo keep the top row on every printed page in Excel for Microsoft 365 on Windows, open the…
- How to Delete an Excel File from SharePointTo delete an Excel file from SharePoint, open the document library that contains it, select the file, choose…
- Compare Lists in Excel: Find Matches and DifferencesWith values in A2:A6 and B2:B5, enter =IF(COUNTIF($B$2:$B$5,A2)>0,"In both","Only in A") in C2 and fill it down to…
- Group Dates by Month in an Excel PivotTable: StepsTo group dates by month in an Excel PivotTable, put a real date field in the Rows area,…
- How to Make a Flowchart in Microsoft Word, Step by StepTo make a flowchart in Microsoft Word, open a document, choose Insert > Shapes, add flowchart shapes for…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.