Fitting your text in your cells is a common challenge in a spreadsheet. There are easy fixes like adjusting the size of your columns or rows, but sometimes those adjustments can alter your spreadsheet view and the best option to make your text fit is to rotate it.

Have you ever tried searching for a rotate button in Google Sheets? You won’t have much luck finding an exact button, but there are workarounds you can use to rotate your text vertically and customize the degree you want to rotate your text. If you are working with a spreadsheet that stores a lot of data and requires filtering, then you may want to insert an image instead. Check out the video above and read the text below to learn these workarounds for rotating text.

To rotate your text vertically:

  • Find the text you want to rotate vertically.
  • Replace the text in the cell with this formula: =ARRAYFORMULA(CONCATENATE((MID( “Text to become vertical”, ROW(INDIRECT(“YY1:YY”&LEN( “Text to become vertical” ))), 1)&CHAR(10))))
  • In the text between the quotation marks (Text to become vertical), replace the text you want to rotate inside those quotation marks. There are two instances in the formula.
  • Hit Enter once you’ve typed out the text.
  • Your text will display vertically.

To customize the degree in which you want to rotate your text:

  • Find and copy the text you want to rotate.
  • Select Insert.
  • Click Drawing.
  • An “Insert Drawing“ window will appear.
  • Select the text box icon and draw your text box.
  • Paste the text you want to rotate into the text box.
  • Adjust the sizing of the text box as needed.
  • Hover your mouse over the top of the text box and wait until you see a plus sign “+.” This symbol means that you are ready to rotate.
  • Rotate the drawing to the degree that works for you.
  • When you are done rotating, click Save and Close.
  • Your drawing is now in your spreadsheet and you can move it around to where you need it to be.
  • To make any adjustments to the text, rotation, color, or other features, select the drawing and find the drop down menu that appears once the drawing is selected.

Click here to watch this video on YouTube.

Shares

UP NEXT: How to Insert a Screenshot or Screen Clipping in Word

Leave a Reply

9 Comments on "How to Rotate Text in Google Sheets"

Notify of
avatar

Sort by:   newest | oldest | most voted
Arlene
Guest
Arlene
April 26, 2016 1:41 pm

I copied and pasted the formula above to rotate text. I replaced the text in both areas, hit enter and got a “Parse Error.

Dylan Press
Admin
Dylan Press
April 27, 2016 7:30 pm

Try this, =ARRAYFORMULA(CONCATENATE((MID( “My Data”; ROW(INDIRECT(“YY1:YY”&LEN( “My Data” ))); 1)&CHAR(10))))

Jerakin
Guest
Jerakin
June 8, 2016 5:13 am

The citation marks are wrong, change them and it should work.

Jerakin
Guest
Jerakin
June 8, 2016 5:13 am

The citation marks are wrong, change them and it should work.

Michael Wallace
Guest
Michael Wallace
April 18, 2016 6:42 pm

Is there a way to rotate text in Google Docs? I want to rotate text 90 degrees to use in a table row header.

Dylan Press
Admin
Dylan Press
April 20, 2016 8:34 pm

You would have to insert a drawing and rotate the text in the drawing. It is a bit of a workaround but the closest you can get right now.

Arlene
Guest
Arlene
April 26, 2016 1:48 pm

How do you change the formula so the text starts from the bottom up instead of top down?

Dylan Press
Admin
Dylan Press
April 27, 2016 7:29 pm

Looking at the formula it seems the best way would be to just write your phrase backwards

Jeanna Wagner
Guest
Jeanna Wagner
April 15, 2016 6:27 pm

This is a terrible “solution.” Sheets should incorporate a dial that allows the user to select the degree of rotation like Microsoft Excel does. I can’t believe that this is a gooru “tip.” Do better Google.

Dylan Press
Admin
Dylan Press
April 20, 2016 7:34 pm

I wish there was a better solution too. This is a workaround because Google doesn’t offer a better solution at this time.

wpDiscuz
Loading Facebook Comments ...

REGISTER

FOR OUR WEBINAR TO GET
THE LATEST 451 RESEARCH REPORT


REGISTER HERE

DOWNLOAD

The Ultimate Guide to Google Drive

DOWNLOAD NOW