To make text vertical in Excel for Microsoft 365 on Windows, select the cell or range, then choose Home > Alignment > Orientation > Vertical Text. This stacks the characters upright; if you want a whole word turned sideways instead, use Rotate Text Up or Rotate Text Down from the same menu.
What “vertical text” means in Excel
Excel offers more than one way to change text direction, and the options can look similar in a compact header. Vertical Text places characters one beneath another, so a label such as “Region” appears as a narrow column of upright letters. Rotate Text Up and Rotate Text Down turn the text as a line, so the word is read by tilting your head rather than reading a stack of letters.
A third approach is to set a custom angle. In the Format Cells dialog, Excel lets you adjust text orientation from horizontal through vertical, including angled positions. This is useful when a modest diagonal angle makes column headings fit without making each character form a tall stack.
These are cell-formatting options, not changes to the text itself. The cell still contains the same value, and a formula referring to it continues to work normally. The setting changes how Excel displays the contents in the worksheet and, generally, in a printout.
How to stack characters vertically
Use the Vertical Text command when you want individual characters to remain upright and appear on separate lines. For example, a short heading such as “Q1” will show the Q above the 1. The practical steps are:
- Select one cell or a range of cells. To format several nonadjacent cells, hold Ctrl while selecting each one on Windows.
- Open the Home tab and find the Alignment group.
- Choose Orientation, then select Vertical Text.
- Adjust the column width or row height if the letters are clipped or the row becomes inconveniently tall.
The exact result depends on the cell’s content and dimensions. A short word may fit in a narrow column, while a longer heading may need extra row height. Excel can display text on multiple lines within a cell, so stacking characters does not guarantee that the entire label will fit in the current row.
To reverse the change, open Home > Alignment > Orientation > Format Cell Alignment. In the Format Cells dialog, set the Orientation angle to 0 degrees and confirm. This resets the text direction without clearing unrelated cell formatting such as borders, number formats, or fill color.
How to rotate a word sideways or at an angle
If the goal is to make a heading fit in a narrow column while keeping the word intact, choose a rotation option rather than Vertical Text. Select the cell, open Home > Alignment > Orientation, and choose Rotate Text Up or Rotate Text Down. Check the worksheet preview and use the direction that makes the labels easiest to read in your table.
For a less steep angle, choose Format Cell Alignment in the Orientation menu. In the dialog’s Orientation area, set the angle using the control or its degree field, then select OK. A small tilt can distinguish headings from data while taking less vertical space than a fully turned label. The direction and angle are matters of presentation; they do not sort or transform the underlying values.
Excel’s rotation is a cell alignment setting, not a free-rotation tool for individual letters. If the design needs each character rotated independently, a text box or another graphic may be more appropriate, though it will not behave like ordinary cell content.
Choose a direction that suits the worksheet
The best orientation depends on what the labels say, who will read the sheet, and whether it will be printed. Vertical Text can work well for single-character markers or very short labels, but a tall stack of letters is often slower to scan than a sideways word. Rotated text is commonly useful for narrow column headings; horizontal text is usually clearest when the sheet has room.
- Use Vertical Text for compact labels where upright characters are intentional, such as a short code or a narrow decorative header.
- Use rotated text when a complete heading needs to fit across a narrow column and remains readable when turned.
- Use a diagonal angle when a slight slant saves space without making labels difficult to compare.
- Keep text horizontal for longer descriptions, accessibility, or worksheets that readers will view on small screens.
For example, a report with columns for “Jan,” “Feb,” and “Mar” may benefit from a modest rotation if there are many periods and the headings otherwise force wide columns. A full label such as “Customer address” is likely to become awkward when rotated; widening the column, wrapping the heading, or shortening it may be clearer.
Cell size, wrapping, and alignment
Text orientation changes how content occupies a cell, so check the dimensions after applying it. A vertically stacked label may need more row height, while rotated text can affect the space Excel allocates along the row and column edges. If a label appears cut off, first select the affected rows or columns and adjust their size rather than assuming the text has disappeared.
On the Home tab, use Format in the Cells group to access row-height and column-width commands. You can also drag a row or column boundary. Double-clicking a boundary can AutoFit its size to content, although a manually chosen size may be preferable when you want a consistent layout across a report. AutoFit results can vary with orientation and neighboring cells, so inspect the full range afterward.
Wrap Text is a separate alignment feature. It breaks long content across lines within the cell’s width; it does not rotate the text. Vertical Text and Wrap Text can both affect the amount of space needed, so if the result is crowded, try one formatting method at a time and review the row height. Merged cells can also make sizing and AutoFit less predictable. For reliable layouts, avoid merging cells where possible; use alignment options such as Center Across Selection when that presentation is suitable.
Formatting ranges and keeping a consistent layout
You can apply orientation to multiple cells at once, which is useful for a complete row of column headings. Select the whole heading range before choosing an orientation so that every label receives the same setting. If only some headings should be rotated, select just those cells; other cells in the row can remain horizontal.
Cell styles and other formatting can be combined with orientation. For instance, a rotated heading can also be bold, centered, and given a fill color. Use the horizontal and vertical alignment controls in the Home tab’s Alignment group to position the text within the cell. Centering may make a set of short headings look more uniform, but it does not change their orientation or the size of the cells.
When copying a formatted heading, Excel may also copy its orientation, fill, borders, and other formatting. If you want the value but not the appearance, use a paste option that keeps values rather than a standard paste. Conversely, if the target cells should match the source design, copying the formatting is useful. Review the destination range afterward, since pasted formatting can override existing layout choices.
Printing and sharing rotated labels
Orientation is part of the worksheet’s cell formatting, so it normally remains visible when the workbook is opened in Excel on another computer and when the sheet is printed. But a screen layout that looks balanced may not fit the page. Before printing, use File > Print to inspect the preview. Check whether narrow columns, tall rows, or page breaks have made the labels hard to read.
If the sheet is too wide, consider changing the page orientation or scaling options in the print settings, but be cautious about shrinking the whole worksheet too much. Tiny rotated labels can be difficult to read on paper. Adjusting margins, choosing a suitable paper size, or printing a selected area may be preferable to scaling everything down. For a shared workbook, use a clear heading or note if the direction might be mistaken for a data issue.
Common problems and fixes
- The letters are stacked, but I wanted a sideways word. Choose Rotate Text Up or Rotate Text Down instead of Vertical Text.
- Only part of the label is visible. Increase the row height or column width, or use AutoFit and inspect the result. Also check for text in a neighboring cell that may affect how content appears.
- The text looks normal after changing the setting. Confirm that the intended cells were selected and check Orientation in Format Cell Alignment. A different cell or a pasted format may have been selected by mistake.
- The whole row became too tall. Reduce the row height or choose a rotated-word or angled setting instead of stacking every character.
- The printout differs from the worksheet view. Review File > Print and check page scaling, paper size, and page breaks before printing.
One common misconception is that vertical formatting changes the value into separate characters or changes how Excel calculates with it. It does not: orientation is visual formatting. If a formula or data import needs the characters separated, that requires a text operation or a different data layout, not the Orientation command.
Windows, Mac, and Excel for the web
The instructions above use Microsoft 365 Excel for Windows. In Excel for Mac, select the cells and look for Orientation in the Home tab’s alignment controls; the commands may be arranged differently depending on the window and ribbon layout. The Format Cells dialog is also available on Mac, though its presentation can differ from Windows. If a ribbon command is not visible, expand the ribbon or open the cell-formatting dialog and look for text orientation under Alignment.
Excel for the web also provides cell alignment and text-orientation controls, but the ribbon layout and available dialog details can differ from the desktop app. If a particular angle or formatting control is unavailable in the web interface, open the workbook in the desktop version of Excel to use its full Format Cells options. In all versions, confirm the appearance in the actual worksheet rather than relying only on the name of a menu option.
Frequently Asked Questions
How do I make text vertical in Excel?
Select the cells, then choose Home > Alignment > Orientation > Vertical Text. This stacks upright characters in the cell. Resize the row or column if the label does not fit.
How do I rotate text 90 degrees in Excel?
Select the cell and choose Rotate Text Up or Rotate Text Down from Home > Alignment > Orientation. These options turn the text as a line rather than stacking its characters. Use Format Cell Alignment to set a custom angle.
How do I make vertical text horizontal again?
Open Home > Alignment > Orientation > Format Cell Alignment, set Orientation to 0 degrees, and select OK. This resets direction while retaining other formatting.
Can I make only one cell’s text vertical?
Yes. Select a single cell before applying the Vertical Text or rotation command. The setting applies only to the selected cell unless you select a larger range.
Does vertical text change the cell’s value?
No. It changes the display, not the contents. Formulas, sorting, and references still use the cell’s original value, although formatting can affect how a person reads the worksheet.
Related
- Data Excel Skills: What They Are and How to Build Them
- Excel Data Tips and Tricks for Cleaner, Safer Workbooks
- Record Data in Excel Online: Setup, Sharing and Tips
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Conditional Formatting in Spreadsheets: How It WorksConditional formatting in a spreadsheet automatically changes a cell’s appearance when its value meets a condition; in Excel…
- Excel Dependent Drop-Down Lists: Link One to AnotherYes. In Excel for Microsoft 365 on Windows, make the first drop-down with Data Validation, create a named…
- Excel PivotCharts: How to Create and Use ThemTo make an Excel chart from a PivotTable, click inside the PivotTable, choose PivotTable Analyze > PivotChart, select…
- Outlook Form Templates: Create and Save OneTo create a reusable custom form in classic Outlook for Windows, enable the Developer tab, choose Developer >…
- How to Add Headers in Excel on SharePoint and Format ThemTo add column headers to an Excel workbook stored in SharePoint, open the workbook for editing, enter a…
- Create a Default Signature in Outlook: Step-by-StepTo create a default signature in Outlook, open the signature settings for your version, create and format the…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.