How to Write Vertically in Excel: 2 Methods

Method 1 – Using Orientation to Write Vertically in Excel

We have a dataset that contains the book name and author of that book. We need to write the book name and author vertically in Excel. Follow the following steps carefully, and you’ll get the desired result.

1.1 Vertical Text Orientation

Steps

Select the cell and the text you want to write vertically. Go to the ‘Home’ in the ribbon. In the ‘Home’ section you’ll get an alignment section where you’ll find an Orientation option such as ‘Orientation’, click on it.

After clicking the Orientation option, you’ll get several options to select. From those options, select ‘Vertical Text’.

Write Vertically Using vertical text Orientation in Excel

When you click the ‘Vertical Text’, you’ll see the text which was selected to make vertical from horizontal has become vertical.

Write Vertically Utilizing vertical text Orientation in Excel

1.2 Rotate Text Up Orientation

Steps

Select the text you want to rotate up.
Like the previous orientation, you need to go to the ‘Home’ tab in the ribbon and find the ‘Orientation’ option. Select the Rotate Text Up option.

Get the desired result when you select the ‘Rotate Text Up’ option.

Write Vertically Utilizing Rotate Up Text Orientation in Excel

1.3 Rotate Text Down Orientation

Steps

Select the text just like we select cell B5 and cell C5 in the Excel worksheet
As we previously stated, first, select the ‘Home’ tab in the ribbon and find the Orientation option. From this option, select the ‘Rotate Text Down’ option.

After clicking this, you’ll get the desired result, just like we get the rotated text-down orientation of the cells.

Write Vertically Utilizing Rotate down Text Orientation in Excel

1.4 Angle Clockwise Orientation

Steps

To make a clockwise orientation, select the cell and the text.
Go to the ‘Home’ tab in the ribbon click on Orientation, and select the ‘Angle Clockwise’ option.

Selecting this option will give you the expected result on your assigned text.

Write Vertically Utilizing Angle Clockwise Orientation in Excel

1.5 Angle Counterclockwise Orientation

Steps

As we mentioned previously, you need to select the preferred cell and the text that you want to be oriented counterclockwise.
Click the ‘Home’ tab and find out the Orientation in which you’ll get the ‘Angle Counterclockwise’ option. Click on it.

After selecting the ‘Angle Counterclockwise’ option, you’ll get the counterclockwise oriented text.

Write Vertically Utilizing Angle Counterclockwise Orientation in Excel

1.6 Rotate Text for a Given Angle

Steps

Start by selecting the cell and the text.
Go to the ‘Home’ tab in the ribbon and search. In this section, you’ll get an option named ‘Format Cell Alignment. Click on it.

By clicking the ‘Format Cell Alignment’ option, you’ll find the ‘Format Cell’ In this ‘Format Cell’. Select the ‘Alignment’ tab. In this tab, you’ll get the degree of orientation.

We can control our degree of rotation by changing degrees. We take 20 degrees of rotation for our selected text.

Apply this orientation, we get a new type of orientation. We can easily set our preferred angle and get the desired result.

Write Vertically Utilizing Rotate Text for a Given Angle in Excel

Method 2 – Using WordArt in Excel to Write Vertically

First, select the ‘Insert’ tab in the ribbon. In this tab, you’ll get the ‘Text’ option.

In the ‘Text’ option, there is a ‘WordArt’ option to select and select the Text style.

A ‘Type the Text’ box will appear in which you must type the name.

To change the orientation, right-click on the text, and the ‘Format Shape’ option will appear.

After entering the ‘Format Shape’ option, select ‘Text Option’ and ‘Text Box’. In the ‘Text Box’ window, change the ‘Text direction’ from horizontal to stacked.