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 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.

 

 

This changes the text orientation to vertical.

 

 

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.

 

 

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) the textbox icon. (3) Click on the box next toText 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 cell with 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.