![]() ![]() In this example we have a set of data that shows the total sales amount per month, for a number of sales reps.Īs you can see in the first image, when the columns are narrowly spaced so that the entire year's sales can be viewed, the names of the months in the header are too long to properly fit within the cells.įor this we will rotate the text up, so that the full name of each month will fit into the columns as they are currently spaced. One of the most common uses for text rotation in Google Sheets is when you want your columns to be tightly spaced, and your headers are too big to view when the columns are narrow. In the examples below I will show you how to make text vertical in Google Sheets, by rotating text up, and down. Okay so let's go over some examples that contain more data in the spreadsheet. How to make text vertical in Google Sheets You can rotate your text in Google Sheet, in the following ways: ![]() You can even choose a custom angle to rotate your text by! Later in this lesson I'll show you how to make text diagonal, and also how to make the borders of the cells diagonal. If you use the text rotation menu that is available directly in the toolbar, you will be able to see an example of what each option will look like.īut the image below shows an even better visual that will help you see how each option will transform your text. Although you can make text vertical with a formula, it's easiest to simply change the formatting of the cell so that Google Sheets easily handles the rotation for you.Ĭlick here to get your free Google Sheets cheat sheet The varying ways to rotate text In just a moment I will show you the different ways that text can be rotated, but for the examples below we will stick to rotating the text upwards and downwards, as these are the two most commonly used rotation options.Īt the end of the article, you will see a section that shows how to rotate text with formulas. In this lesson I will show you several examples of rotating the text inside of cells, and what the text looks like both before and after having been rotated. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |