How to type in portrait orientation in Microsoft Excel? step by step guide

Microsoft Excel is a program spreadsheetsat least that is its main function. However, it is also very versatile software and recommended for making any kind of comparative charts. Also works great for order information.

Reasons for this are for example its coloring tools, layouts and text orientation. These utilitiesalong with others, are used to facilitate reading at the same time that they remove monotony from the document.

In particular, changing the orientation of a cell can be very useful in that regard. If you want to know how to modify this parameter, we recommend this post.

When is it better to write vertically than horizontally on a spreadsheet?

The main reasons for making this change are above all aesthetic and dynamic. We recommend you use it when the title of a column is disproportionate to the width of the content subsequent. That is, when you have columns with very short texts or numbers with few digits and the title is too wideyou can rotate it.

For example, a column containing “Yes” either “No” and its header is “Dominican Republic”. It can also happen in a weekly stock control, where the values ​​are numbers less than one hundred. In this way it will remain “Monday 18”, “Tuesday 25”etc.

But it is not only possible to orient a text horizontally or vertically. so is choose any angle of rotation. This is especially useful for double entry tables. Being able to fill the first cell with the column and row description. (As shown in the picture).

Learn step by step how to write vertically in an Excel spreadsheet

In short, the reason why you decide to rotate a text will always depend on your needs. What if we can tell you precisely, is the method to follow to make it.

To do this, continue with these steps:

• Start Microsoft Excel. If you don’t have a shortcut on your desktop, you’ll find it in the “Start menu”.
• Create a new template or open one you want to modify. You can do either of these two options from the welcome page.
• Select the cell(s) containing the text to verticalize.
• Within the tab “Start”you will find the section “Alignment”.
• In it press the icon made up of the letters “ab” on a diagonal arrow.
• Doing so will display five direct ways. Which are “Ascending angle, descending angle, vertical text, Rotate text up and down”.
• You will notice that none of them contain “horizontal text”this is because if you need to return the text to its original orientation you will only have to disable the button you used to rotate it.
• Within the quick alternatives offered by this dropdown, there are two ways to make a text vertical. The first is “vertical text”, which arranges the characters one on top of the other, without actually rotating them. The second preserves the respective angle of the same, but rotates the set.
• It is important to say that, in the latter, the alignment actions will take the cell as if it were horizontal.

In the event that you want to rotate the words included in one or several boxes to a specific angle, you must do the following:

• Select the same.
• Right-click on them.
• Choose “Cell format”.
• In this new window, you must choose the tab “Alignment”.
• Within it you will have to indicate the degrees of rotation in the section “Orientation” or do it freehand with the interactive box.
• To undo this transformation, perform the same steps as in the previous case.