Update 2/22/17: Google has now added a built-in Rotated text feature in Google Sheets. Just go to Format > Text rotation. For more information, check out this post.  

If you work in IT, learn how BetterCloud’s Unified SaaS Management platform can help you manage G Suite and other applications. Also, learn how you can 10x your G Suite productivity

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

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

Notify of
avatar
Sort by:   newest | oldest | most voted
Arlene
Guest
Arlene

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

Judith Tucker
Guest

Same thing happened to me. I even tried Dylan Press’ suggested reply code below from 4/27/16 and still got Parse Error. What am I doing wrong? I didn’t even substitute anything for “My Data.”

Dylan Press
Guest
Dylan Press

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

Jerakin
Guest
Jerakin

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

Jerakin
Guest
Jerakin

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

Jeanna Wagner
Guest
Jeanna Wagner

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
Guest
Dylan Press

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

Michael Wallace
Guest
Michael Wallace

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
Guest
Dylan Press

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

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

Dylan Press
Guest
Dylan Press

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

wpDiscuz

DOWNLOAD

The Ultimate Guide to Google Drive

DOWNLOAD NOW