How to wrap text and merge cells in Google Sheets

Published June 12, 2022

In this article, we will learn how to style/format our cells to give our Google Sheet spreadsheet a professional appearance. To make our cell content simpler to read, we'll learn how to wrap text and combine cells in Google Sheets. In this post, we will discuss the following topics:

  • How to wrap text

  • How to marge cells

 

How to wrap text

Take a look below at the simple steps to wrap text in Google Sheets:

Step 1:   The first step is to select the cells you want to wrap. We are going to select cells B2 to B5. It is apparent that some of the content in these cells doesn't fit, and some text is hidden.    

How to wrap text and merge cells in Google Sheets

 

Step 2: Now open the Text wrapping dropdown menu and clickwrap button

How to wrap text and merge cells in Google Sheets-2

 

Step 3: the cells will be resized automatically to  fit their contents 

How to wrap text and merge cells in Google Sheets-3

 

Our text now perfectly fits the cells.

How to merge cells

Now let's see how we can merge cells.

Step 1: First, select the cells that you would like to merge. In our case, we are going to select the cells A1: C1

How to wrap text and merge cells in Google Sheets-4

 

Step 2:  Now click on the "merge cells" button. On the confirmation box, click “Ok” to proceed.

How to wrap text and merge cells in Google Sheets-5

 

Step 3:  The selected cells will be merged into a single cell

How to wrap text and merge cells in Google Sheets-6

 

Conclusion

That's all about cell merging and text wrapping in Google sheets. To unmerge the cells, just click the drop-down arrow next to the merge cells button and then pick unmerge from the drop-down menu

 

Keywords: Google Docs, Google Sheet, How to wrap text and merge cells in Google Sheets

Related Google Sheet Question and Answers

How do i create new google sheet

How to delete a sheet in google sheet

How to duplicate google sheet

How to modify rows width columns and cells in google sheet

How to copy and paste cells in google sheet

How to drag and drop cells in google sheet

How to insert data using the fill handle the feature google sheet

How to insert,move and delete rows and columns google sheet

How to select cells in google sheet

How to freeze rows and columns google sheet

How to wrap text and merge cells google sheet

How to change the font size in google sheet

How to change the font in google sheet

How to change text color in google sheet

How to make text bold in google sheet

How to add cell border in google sheet

How to change the cell background color google sheet

How do i align text in google sheet

How to create a complex formula using the orderof operations google sheet

How to create and copy formulas using relative references google sheet

How to use absolute references to create a copy and paste formula google sheet

create formulas using functions in google sheets

How to sort and filter data in google sheets

How to insert image in google sheets

How to rotate text in google sheets

How to enable spell checker in google sheets

How to enable auto complete in google sheets

How to download google sheets

Article Contributed By :
https://www.rrtutors.com/site_assets/profile/assets/img/avataaars.svg

91 Views