When it comes to writing, it is very common to write characters, texts, and numbers horizontally. It appears from the left and finishes at the right corner. But sometimes you may need to write vertically or at a given angle. Vertical writing initiates either from top to bottom or from bottom to top. This article will give you a platform on how to write vertically in Excel.
Download Practice Workbook
Download this practice workbook
2 Ways to Write Vertically in Excel
Here, We discuss two different methods to write vertically in Excel. One method is by using orientation and the other is by using WordArt.
1. Write Vertically Using Orientation in Excel
We have a dataset that contains the book name and author of that book. We need to write that book name as well as the author vertically in Excel. To do this you need to follow the following steps carefully and you’ll get the desired result.
1.1 Vertical Text Orientation
Vertical orientation is a type of orientation where your selected data becomes vertically aligned. To do this type of orientation follow the following steps.
- When you have the dataset, first you need to select the cell and the text you want to write vertically. Then 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’.
- When you click the ‘Vertical Text’, you’ll see the text which was selected to make vertical from horizontal has become vertical.
1.2 Rotate Text Up Orientation
If you want to rotate your text up, you need to follow the following steps
- First, you need to 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. In that option, you’ll get six different options and you need to select the Rotate Text Up option.
- When you select the ‘Rotate Text Up’ option, you’ll get the desired result.
1.3 Rotate Text Down Orientation
- Similarly, you need to select the text just like we select cell B5 and cell C5 in the Excel worksheet
- As we previously stated, first you need to select the ‘Home’ tab in the ribbon and find the Orientation From this option you need to select the ‘Rotate Text Down’ option.
- After clicking this, you’ll get the desired result just like we get the rotate text down orientation of the cells.
1.4 Angle Clockwise Orientation
- To make a clockwise orientation, you need to select the cell and the text.
- Next, go to the ‘Home’ tab in the ribbon and click on Orientation and select the ‘Angle Clockwise’ option.
- When you select this option, you’ll get the expected result on your assigned text.
1.5 Angle Counterclockwise Orientation
Angle Counterclockwise orientation will do the exact opposite orientation compared to clockwise orientation.
- As we mentioned previously, you need to select the preferred cell and the text which you want to be oriented counterclockwise.
- Now, 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.
1.6 Rotate Text for a Given Angle
This orientation will give you a platform to rotate text for a preferred angle. Here, you can set the angle of rotation through which the text will rotate. To do this you need to follow the following steps.
- Just like other orientation processes, you need to start by selecting the cell and the text.
- Then 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’. Here, selects the ‘Alignment’ tab. In this tab, you’ll get the degree of orientation.
- We can control our degree of rotation by changing degrees. Here, we take 20 degrees of rotation for our selected text.
- When we apply this orientation, we get a new type of orientation. We can easily set our preferred angle and get the desired result.
2. Write Vertically Using WordArt in Excel
Another useful method to write vertically in Excel is to use WordArt. To do this you can follow the following processes.
- First, you need to 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 need to type the name.
- In order to change the orientation, right-click on the text then 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.
- When you finish all the steps, you’ll get the vertical orientation of your text.
Problems with Clockwise and Counterclockwise Orientations
If you look at our result closely, you will find that we use all borders in all orientations except these two orientations. The main reason is that if we use borders in these two orientations then the borderline will also move with the text value like the following one.
We discussed two different methods to write vertically in Excel. Both of the methods are equally effective to write vertically in Excel. If you have any questions, you can comment below and for further knowledge visit ExcelDemy.