• Home
©2023 - The Better Parent. All Right Reserved. Designed & Developed by Theory Solutions

How to Rotate Text in Google Sheets | MakeUseOf

by Saikat Basu September 24, 2020
September 24, 2020 35 views
35

In Google Sheets, you can fit text in a cell by adjusting column and row sizes or by using a text wrap. But sometimes they can make the spreadsheet more difficult to read. In such situations, try to rotate the text in a cell instead of adjusting the width of columns and rows.

Rotating text in Google Sheets is best suited for headers forced inside narrow columns. But you can rotate any data in any cell.

The Simple Way to Rotate Text In Google Sheets

Select the cell or cells you want to rotate. In our example, we will select the header row. You can use two methods to rotate the data in the cells.

Use the Text Rotation Button. Select the button on the toolbar with a slanted letter “A”, as shown in the screenshot directly below.

Use the Format Menu. Select the Format menu in the toolbar. Then choose Text rotation as shown in the screenshot below.

You can use either of the two methods. All you have to decide in the next steps is the direction and angle of the data you want to display in the cells. Both methods allow you to set a custom angle too.

Change Text From Horizontal to Vertical in Sheets

You can orient text vertically when the space between columns is tight.

  1. Select the range of cells in the header row A1:G1.
  2. Go to the toolbar and select Format > Text rotation. Select Rotate up.
  3. You can also choose to use Rotate down which reverses the orientation of the letters. Screenshot of vertical text in Google Sheets

Notice the difference of these two with the Stack vertically option which just flips the text and display it vertically instead of horizontally.

How to Rotate Text With a Text Box

A text box is a good way to display a large block of text or punch up the look of statistical data in your spreadsheet. A Text Box can also be oriented in any direction you want. Use these steps to insert a text box with your chosen text.

  1. Select Insert > Drawing.
  2. In the Drawing window, select the Text box icon and drag to draw it on the canvas.
  3. Type your text and format it if you want. Adjust the size of the text box as needed.
  4. Hover your mouse near the top of the text box till you see a plus sign “+”. Use this to rotate the text box to the angle you want.Insert drawing to rotate text in Google Sheets
  5. Click Save and Close to insert the text box in your spreadsheet. You can now drag and place it anywhere on your sheet.

Learning to rotate text in Google Sheets takes just a few seconds. But it can go a long way to help you manage densely packed data in your spreadsheet. Pick up a few more simple Google Sheets tips to boost your productivity.

Source: makeuseof.com

makeuseofProductivity
0 FacebookTwitterPinterestEmail
previous post
U.S. Department of Education Launches Rethink Adult Ed Challenge to Grow Pre-Apprenticeship Opportunities for Life-long Learners
next post
Variation in genes associated with viral entry of SARS-CoV-2 unlikely to influence COVID-19 morbidity and mortality, study finds

Related Posts

How to Add Signatures to PDFs Using Preview...

June 3, 2023

8 Common Tech Career Mistakes and How to...

June 3, 2023

11 Must-Know JavaScript and TypeScript Shorthands for Efficient...

June 3, 2023

What Is Clean HDMI Output? How to Set...

June 3, 2023

What Is Being Chronically Online and How Can...

June 3, 2023

How to Enable Write Protection on a SD...

June 3, 2023

Trending

  • 3 Ways to Edit the boot/config.txt File on Raspberry Pi

    August 30, 2018
  • 6 Tools to Sync Microsoft Outlook With Google Calendar

    January 7, 2019
  • How to Vectorize an Image in Adobe Illustrator

    March 29, 2019
  • What Does This Emoji Mean? Emoji Face Meanings Explained

    May 24, 2019
  • The 8 Best DIY Security Camera Apps and Software for Linux

    May 31, 2019

©2023 - The Better Parent. All Right Reserved. Designed & Developed by Theory Solutions

Related Articlesx

Apple Maps Now Shows COVID-19 Health Measures...

How to Brainstorm Ideas With the How...

Up Your Photography Game With Canon This...