

This will shrink the width of the columns subsequently shrinking the width of the dataset for compacting the data and/or for fitting more columns in. Evidently, it would be a good idea here to rotate the text diagonally. If we were to add more columns to this dataset, there would be a lot of scrolling back and forth. Here is our problem case for this tutorial we will be meddling with the headers in row 2: Of course, there's also a little thing called Word Wrap but let's not steal text rotation's limelight for one-word headings, what good would Word Wrap be? Now let’s get down to the practical part of this guide. Depending on where the text sits and which setting is applied, the orientation of the text can save some space making the data more compact and easier to read. Well, sure, that’s not a bad reason for rotating text but there is a bit more to this than just looks. What’s the purpose of rotating the text? Should you do it because it’s something new you found out and it looks more interesting. You will learn how to adorn your worksheets with vertical text and diagonal text and how to restore the text in case you don’t like the changes.īy text rotation, we mean changing its orientation from horizontal to diagonal or vertical.

Do you remember seeing vertical text somewhere and tried to copy that style into your sheets by typing each letter with Alt + Enter in between? If we have spotted you correctly, today is your day and this post is for you.
