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

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