How to Write Sideways in Excel

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.

Step

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

Step

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.

Step

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.

Step

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