How to Write Vertically in Excel (2 Ways)

Get FREE Advanced Excel Exercises with Solutions!

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


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

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

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

If you want to rotate your text up, you need to follow the following steps

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.

Write Vertically Utilizing Rotate Up Text Orientation in Excel


1.3 Rotate Text Down Orientation

Steps

  • 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 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, you need to select the cell and the text.
  • Next, go to the ‘Home’ tab in the ribbon click on Orientation, and select the ‘Angle Clockwise’ option.

  • When you select this option, you’ll get the expected result on your assigned text.

Write Vertically Utilizing Angle Clockwise Orientation in Excel


1.5 Angle Counterclockwise Orientation

Angle Counterclockwise orientation will do the exact opposite orientation compared to clockwise orientation.

Steps

  • As we mentioned previously, you need to select the preferred cell and the text that 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.

Write Vertically Utilizing Angle Counterclockwise Orientation in Excel


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.

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

Write Vertically Utilizing Rotate Text for a Given Angle in Excel

Read More: How to Change Text Orientation in Excel


2. Using WordArt in Excel to Write Vertically

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.

Write Vertically Using WordArt in Excel

Read More: Difference Between Alignment and Orientation in Excel


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.


Download Practice Workbook


Conclusion

We discussed two different methods to write vertically in Excel. Both of the methods are equally effective for writing vertically in Excel. If you have any questions, you can comment below.


Related Articles


<< Go Back to Rotate Text | Text Formatting | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Durjoy Paul
Durjoy Paul

Durjoy Kumar, with a BSc in Naval Architecture & Engineering from Bangladesh University of Engineering and Technology, is a dedicated contributor to the ExcelDemy project. His substantial contributions include crafting numerous articles and demonstrating expertise in Excel and VBA. Durjoy adeptly automates Excel challenges using VBA macros, offering valuable solutions for user interface challenges. Apart from creating Excel tutorials, he is interested in Data Analysis with MS Excel, SPSS, C, C++, C#, JavaScript, Python Web Scraping, Data Entry... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo