How to Write Text Vertically in Excel & Google Sheets

This tutorial demonstrates how to write text vertically in Excel and Google Sheets.

 

write vertically 4

 

Write Vertically

Text Alignment

Say you have text you want to write vertically (in this example: Excel) using the orientation option in Excel.

 

write vertically 3

 

  1. Select the cell with text you want to write vertically.
  2. Then in the Ribbon, go to Home.
  3. In the Alignment group, click the orientation icon.
  4. From the drop-down list, choose Vertical Text.

 

write vertically 1

 

This changes the text orientation to vertical.

 

write vertically 2

 

WordArt

Another way you can achieve vertical writing in Excel is to use WordArt.

  1. In the Ribbon, (1) go to Insert, (2) click on the WordArt icon and (3) choose the text style.

 

write vertically 6

 

  1. After that, type the text into the box.

 

write vertically 7

 

  1. To change the orientation of the text, right-click on the box with text and from the drop-down list, choose Format Shape…

 

write vertically 8

 

  1. In the Format Shape dialog box (1) click on Text Options, then (2) the textbox icon. (3) Click on the box next toText direction, and from the drop-down list, (4) select Stacked.

 

write vertically 9

 

As a result, the text is displayed vertically.

 

write vertically 10

 

You can also choose the option to rotate all text 90° to achieve the effect of vertical text.

 

write vertically 12

 

Or you can select the option to rotate all text 270°.

 

write vertically 13

 

Write Vertically in Google Sheets

In Google Sheets, you can write vertically using the text rotation feature.

  1. Select the cell with text you want written vertically.
  2. Then in the Toolbar click on the Text Rotation icon.
  3. Choose Stack Vertically.

 

write vertically 14

 

This changes the orientation of the selected text to vertical.

 

write vertically 15