How to Write Sideways in Excel

Written by danielle cort
  • Share
  • Tweet
  • Share
  • Email

If your spreadsheet has a lot of data that results in narrow columns, such as two-digit numbers that take up very little space, adding long column headings can make your columns much wider than your data. Row headings that are long can also create a spreadsheet with unnecessarily wide columns that significantly expand your spreadsheet and create too many printed pages. One solution is to turn select text sideways to create a more streamlined look.

Skill level:
Moderately Easy


  1. 1

    Open Excel to a blank spreadsheet or open an existing spreadsheet.

  2. 2

    Click a cell you want to add text to. Click the "Home" tab on the ribbon if it is not already open. Click the "Text Orientation" button in the Alignment group. The button has no name but shows the letters "ab" with an arrow underneath pointing diagonally.

  3. 3

    Select the type of rotation you want. You can select "Vertical text" to have letters appear vertically one at a time in your cell or select "Rotate up" or "Rotate down" to face your text left or right.

  4. 4

    Type the text as you would normally. Press "Enter" to see your text align sideways.

Tips and warnings

  • Align your text left, right or centre after you have turned it sideways by clicking one of the alignment icons in the Alignment group.

Don't Miss

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.