MS Excel is a program at least that is its main function. However, it is also a very versatile software and recommended for making any type 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 take away 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 in a spreadsheet?
The main reasons for making this change are above all aesthetic and dynamic. We recommend you use it when a column title 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 such a 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 description of column and row. (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 we can tell you precisely is the method you should 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 or cells that contain the text to verticalize.
- Inside 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 shapes. Which are “Ascending, 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 deactivate the button that 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 their respective angle, but rotates the set.
- It is important to say that, in the latter, the alignment actions they 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 at a specific angle, you must do the following:
- Select the same.
- Press the right mouse button 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.
Facebook Comments
Disqus