How to write vertically in Excel?

Usually we are writing horizontally, but sometimes there is a need to rotate text vertically or at an angle. In this article, I will show you how to write vertically in an Excel file. We will type horizontally, as we normally do, and then we will use different options to rotate the data as per the requirements. Such cell formatting might be needed to increase visibility or for sophisticated presentations that you may be making.

How to write horizontally?

Write any text in cell A1 normally:

write horizontally

How to write vertically?

Then choose the option Home > Alignment (select Orientation or ab->) to rotate it vertically:

Orientation

Select vertical text as shown below:

vertical text

It will turn the text into the Vertical Text form as shown below:

Vertical Text form

Similarly, we can experiment with other options like:

Rotate text up

It will turn the text upside down, starting from below:

Rotate text up

Rotate Text Down

It will turn the text upside down, starting from above:

Rotate Text Down

Angle Clockwise

It will rotate the text at 45 degrees, as shown below:

Angle Clockwise

Angle Counter Clockwise

It will rotate the text at 45 degrees, as shown below:

Angle Counter Clockwise

I have added all the types of text explained in the article. It will show all the text forms in different cells.

all types of the text types explained

Note: You can also use the “Wrap Text” feature in Excel to make text appear on multiple lines within a cell, instead of being written vertically. To do this, go to the Home tab in the ribbon, and click the “Wrap Text” button in the Alignment section.

See also  How to resolve Excel stopped interacting with windows and was closed issue

Using the Text Box Feature

To write vertically in Excel using the text box feature, follow these steps:

  1. Click the Insert tab in the ribbon.
  2. In the Text group, click the Text Box button.
  3. Click and drag on the worksheet to draw a text box.
  4. Type the text that you want to rotate into the text box.
  5. Right-click on the text box and select Format Shape.
  6. In the Format Shape dialog box, click the Text Options tab.
  7. Under Text direction, select Stacked.

You can also use the Text Box feature to create vertical text labels for charts and graphs.