How to wrap text in Google Sheets

Learn how to make text-filled cells in Google Sheets easier to read with text alignment and adjustment settings

"data-credit =" Illustration: Andy Wolber / TechRepublic "rel =" noopener noreferrer ">   Displays 3 sets of 3 text cells, with arrows between: (bottom left) A whole line, the text overflows then cell, (center) Text setting enabled, (top right) Setting enabled, alignment changed to the left and top of the cell.

Illustration: Andy Wolber / TechRepublic

Some people use Google Sheets to manage text. For example, some colleagues use a Google sheet with rows and columns that contain detailed descriptions of specific features of the software; others use a Google sheet to serve as a project planning and / or monitoring tool, with text describing key project milestones, details and future actions. These Google Sheets often contain more text than numbers.

SEE: 10 free alternatives to Microsoft Word and Excel (Free PDF) (TechRepublic)

By default, the text in a Google Sheet cell is aligned to the left and bottom side of a cell, with the text overflowing adjacent blank cells. Unless the cell format of the Google Sheet is changed, these options can make it difficult to read your spreadsheet. Often, I encourage people to make three text alignment settings.

  1. For many cells, change the vertical alignment up, which ensures that the text begins at the top of each cell.
  2. Then, adjust the horizontal alignment to the left, so that the paragraphs are read the same way they would in a document.
  3. Third, enable text wrapping to ensure that all text is displayed in a cell.

The combination of these three changes helps create a Google sheet with many texts. Easier to read fields ( Figure A ).

Figure A

The text wrapping and alignment options in Google Sheets are displayed in the Format menu.

"data-credit =" http: // www.techrepublic.com/ "rel =" noopener noreferrer ">   Screenshot of Google Sheet with Format> The text setting menu is displayed". data-original = "https://tr1.cbsistatic.com/hub/i/r/2019/09/19/6a820d63-14ff-4c55-b194-91446ecb865f/resize/770x/2be941707705d09e0c1f395ee24a9ce9/format-align-textwrapperic .jpg

The text setting and alignment options in Google Sheets are displayed in the Format menu in the browser. Chrome from a computer, as well as the Google Sheets application for Android or iOS These settings can be made from the Format menu options in Google Sheets or with the alignment and adjustment icons ( Figure B ).

Figure B

If you prefer, Google Sheets also offers horizontal alignment, vertical alignment and text adjustment icons with access to the three settings for each.

"data- credit = "http: //www.techrepublic.com/" rel = "noopener noreferrer"> [19659021] 3 screenshots of the menu icon: (top) horizontal alignment (feet, center, right), vertical alignment (center) (top, bottom center), overflow (bottom), adjustment, clip. ” data-original=”https://tr1.cbsistatic.com/hub/i/r/2019/09/19/bacfe157-0241-43ab-8254-1774c0031fb7/resize/770x/9acfc4863e8f4bebbd746f387acf83fa/halign-valign-wrap-icons.jpg”/>

If you prefer, Google Sheets also offers horizontal alignment, vertical alignment and text adjustment icons with access to all three settings for each.

How to change text setting settings in Google Sheets

With a text cell selected, choose Format | Text wrapping | Overflow option. Text in a cell overflows adjacent blank cells. This is the default value.

On a Google sheet with lots of text, you can choose Format | Text wrapping | Adjust so that each word in a cell is displayed. The cell will increase in size vertically to display the text. After you enable text wrapping, you may also want to change the width of the columns.

Google Sheets in Chrome on a computer also offer a Format | Text wrapping | Clipping option that truncates the display of the text to the width of the cell ( Figure C ).

Figure C

Google Sheets offers three text adjustment options: Overflow, Adjustment and Clip. The overflow, the default, extends the text over any adjacent blank cell. The adjustment maintains the width of the column and extends the height of the row to display all the text. Clip truncates the display of text in a cell the width of the cell.

"data-credit =" http://www.techrepublic.com/ "rel =" noopener noreferrer ">   figurec-overflow- wrap-clip-revised20190925.jpg figurec-overflow-wrap- clip-revised20190925jpg [19659018font>GoogleSheetsofrecetresopcionesdeajustedetexto:DesbordamientoAjusteyClipDesbordamientoelvalorpredeterminadoseextiendetextosobrecualquierceldaadyacenteenblancoLaenvolturamantieneelanchodelacolumnayextiendelaalturadelafilaparamostrartodoeltextoCliptruncalavisualizacióndeltextoenunaceldaalanchodelacelda

changing settings vertical alignment in Spreadsheets Google

When you have multiple cells containing a sentence or more text, try Format | Align | Up to many. people find it easier to read, since the text in each cell will start at the level I otherwise, the height of the first word in each cell may vary.

Alternative settings include Format | Align | Medium, whichworks well for row titles, and Format | Align | Bottom, which works well with rows and / or short text cells not long enough to fit ( Figure D ).

Figure D

You can adjust the alignment of the text within a cell up, middle or bottom.

"data-credit =" http://www.techrepublic.com/ "rel =" noopener noreferrer ">   figured-aligntop-mid-bottom-revisied20190925.jpg" data-original = "https: / /tr2.cbsistatic.com/hub/i/r/2019/09/25/7f50d63d-a43a-4937-a6d5-7e80cfbe95a5/resize/770x/504694ea3f516741a93ed2b7042848c8/figured-aligntop-mid-bottomigop. -mid-bottom-revisied20190925.jpg

You can adjust the alignment of the text within a cell at the top, middle or bottom.

How to change the horizontal alignment setting in Google Sheets

For cells that contain sentences or paragraphs of text, try Format | Align | Left (or Ctrl + Shift + C) .This matches the alignment that people may be accustomed to when they read text in traditionally read languages ​​from left to right , as an English, German, French, Spanish, etc. ( Figure E ).

Heads them Two column and / or row can work well when centered: Format | Align | Center (or Ctrl + Shift + E). And, in some cases, a column or row that functions as a header can benefit from the alignment to the right, Format | Align | Right (or Ctrl + Shift + R).

Figure E

Align the text on a Google sheet to the left, center or right, either with Format | Align the menu options or with keyboard combinations.

"data-credit =" http://www.techrepublic.com/ "rel =" noopener noreferrer ">   Screenshot of the Google Sheet with the text aligned to the left, center and right: Keyboard commands: Ctrl + Shift + L, Ctrl + Shift + E, and Ctrl + Shift + R, respectively. " data-original = "https://tr2.cbsistatic.com/hub/i/r/2019/09/19/6518ccf3-2ca5-4b40-b471-165a5012abb4/resize/770x/db35ae3af36a6a070119f437c5bc7553/example-left-center-right .jpg

Align text on a Google sheet left, center or right, either with the menu options Format | Align or with keyboard combinations.

Mobile applications from Google Sheets: How to change the setting and Text alignment

In the Google Sheets application on Android and iOS, you can select a cell (or cells), then touch the Text / Cell format icon in the upper right corner (shown as an A with some horizontal lines to the right.) This shows the Text and Cell formatting options. [19659027] Mobile Googl e Sheets includes access to the three horizontal and vertical alignment options shown: left, center, right and top, center and bottom. However, the Google Sheets app offers a unique slider for text wrapping. Touch Cell, then choose whether the Adjust text option is enabled or disabled ( Figure F ).

Figure F

In Google Sheets on Android or iOS, select a cell (or cells), then touch the text / cell editing icon in the upper right corner, shown as an A with horizontal lines to the side. From there, you can adjust the alignment settings (horizontal and / or vertical), or touch Cell, then adjust the Adjust text slider.

"data-credit =" http://www.techrepublic.com/ "rel =" noopener noreferrer "> www.techrepublic

If you work with Google Sheets that contain a significant number of text fields, that fit and align. Which configuration do you prefer? Do you, like me, often adjust this setting when you open a spreadsheet with lots of text? Let me know how you more frequently format text fields in Google Sheets, either by adding a comment below or sharing it on Twitter ( @awolber ).

See also

For More Updates Check out Blog, Windows Softwares Drivers, Antivirus, Ms Office, Graphic Design Don’t Forget to Look Our Facebook Page Get Into Pc like us & follow on Twitter- @getinpc

Please Note: This content is provided and hosted by a 3rd party server. Sometimes these servers may include advertisements. igetintopc.com does not host or upload this material and is not responsible for the content.