If you're watching this video you're probably using Google sheets
and you're wondering how you can rotate the text in a Cell
similar to how you do it in Excel
or maybe you're just wondering because you have a need for it. You might want
to do it for your row headers
there's not a straightforward way to do it. There's no easy way to do it through the
menus
but there are some workarounds and I'm going to show
several of them to you right now. They each come with a different caveats
so you have to figure why you're using them to figure out which one that you want
The first one is just to
insert a text box and then rotate the text box
it's not readily apparent actually how to
insert a text box into sheet either. So how you do it is -
You go to insert and then go down to drawing at the bottom
and in the insert drawing dialog, there's a text box option.
Choose that. Draw your text box. Type in the text.
Then size it.
The way to rotate is using this little handel
up here. You want to hover over the circle
hold your left button-down and rotate it as much as you want. So
obviously you can even do diagonal with this if you want. And then do save and close.
and then put your text in. That's good in that you can rotate it however you want
and that's kinda the behavior that we're used to from using Microsoft Excel if
you have
the bad thing is this doesn't actually going in a cell. It floats on top because
this is a text box.
So you can put it exactly where you want
but the rows are not going on to auto-size if you had a row
on top, it might not shift down
it doesn't behave like normal cell. That could could be good or could be bad depending
on what you're doing.
The next option is that you can
type your header in a cell and then you take that cell
and you just make it really skinny.
Then you have to have on the word wrap so I'm gonna go over to the menu to
the right
and I'm going to select text wrapping and then wrap
and that will wrap the text. Now you notice that made it go down vertically
but the letters are still going left to right so it's little bit different
behavior
but for better or worse it does resize
the height of the column. Then there's two formulas that you can use
and I'll put these in description of the video on YouTube so you can just copy and
paste them.
You take this formula, replace
the cell that says "Text to become vertical" (it's in here twice),
replace that text.
I made this formula show by putting a single quote before it.
When you take the single quote off it does it's magic.
There it is, it makes it vertical. When I go into it, it wants to put a little scroll box into it, that's
why it's
acting weird to make you a bit larger. There's text to become
vertical. Same thing. This is just another type of formula.
I would use this one personally. It's just shorter.
After seeing this one, I don't know why you'd use the other one but I put it in there
just because it works
And you can see in again I have a little single quote before do it's not doing anything here.
But, you replace this text with your text
and it makes it go up and down. now The
column width doesn't matter here, on these two formulas and that
makes it a bit easier than the option of putting it in a column in making it
skinny.
The last thing that you can do, and
the advantage of this is that there is no formula. You just to control enter
after every character
so if I hit a J (or an H) hit a J
hold on control in a press enter it will go to the next line
but still in same cell. Just do that
until you have it all typed. You can do a couple on a line if you want and then hold down control
and press enter. And that way, you can get your vertical header.
Hopefully out of those five
options, you can find something that works for you.