How to Make Text Vertical in Excel (2 Easy Ways)

You may have created a datasheet in Excel, but sometimes you may need to make the text in your Excel sheet vertical to make your data more reader-friendly. In this article, I will show you how to make text vertical in Excel.


Download Practice Workbook


2 Easy Ways to Make Text Vertical in Excel

In this section, you will find 2 quick ways for making text vertical in your Excel workbook. Let’s check them now!


1. Make Text Orientation Vertical

Let’s say, we have got a dataset of sales of the sales assistants of a shop over a certain period of time.

Dataset for Making Text Vertical

All of the texts in this Excel sheet are horizontally aligned. We want some texts to make vertically aligned.

To make text vertical, follow the steps below:

  • First of all, select the cells containing the text you want to be vertical.
  • Then, go to the Home tab> Orientation icon> click Vertical Text.

Making Text Vertical in Excel

  • And now, your text will be vertically aligned.

make Text Vertical in Excel

So easy, isn’t it? You can now make your text in an Excel sheet vertical in the blink of an eye!


2. Use WordArt Icon to Make Text Vertical

For our previous dataset, we’ll now learn to make text vertical by using the WordArt Icon of Excel. And for this, just follow the steps below:

  • First of all, select a cell where you want the text.
  • Then, go to the Home tab> click Text > select WordArt icon> choose a design.

Making a Text Vertical in Excel

  • Here, a box will show up containing “Your Text here”  like the screenshot below.

Making Texts Vertical in Excel

  • Now, type something that you want to make vertically aligned. (i.e. Vertical)

  • After that, select the text> right-click on it> select Format Shape.

  • In the meantime, the Format Shape dialogue box will show up.
  • Now, select Text Options>click Text Box> select Stacked from the Text direction option.

  • Finally, your text will be vertically aligned.

In this way, you can easily make your text vertical by using the WordArt icon.


Things to Remember

  • If you want to change your vertical text back to horizontal, just click on the vertical orientation again. As there is no option for horizontal orientation, clicking again an option will make it disabled.
  • Converting text to vertical orientation sometimes may cause unexpected things to happen based on the row/column size.
  • After converting text to vertical, the cell size can be adjusted manually by using the cursor.

Conclusion

In this article, we have learned how to make text vertical in Excel. I hope from now on, you can quickly make your text vertical in Excel. If you have any better methods or questions or feedback regarding this article, please share them in the comment box. This will help me enrich my upcoming articles. For more queries, kindly visit our website ExcelDemy.

Rafi

Rafi

Hey there! I am Md. Rafiul Hasan. Currently I am working as an Excel & VBA content developer. I like new ideas and want to explore the field of innovation. Excel has saved our worktime and made it easy for us to quick calculations. I am trying to make it easier for you to overcome the obstacles you face while working on Excel. Stay connected!

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo