How to Write Text Vertically in Excel & Google Sheets

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

 

 

Write Vertically

Text Alignment

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

 

 

1. Select the 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.

 

 

This changes the text orientation to vertical.

 

 

WordArt

Another way you can achieve vertical writing in Excel is to use WordArt. In the Ribbon, (1) go to Insert, (2) click on the WordArt icon and (3) choose the text style.

 

 

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

 

 

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

 

 

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

 

 

As a result, the text is displayed vertically.

 

 

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

 

 

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

 

 

Write Vertically in Google Sheets

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

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

 

 

This changes the orientation of the selected text to vertical.