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.
 |
Step 2: Now open the Text wrapping dropdown menu and clickwrap button
 |
Step 3: the cells will be resized automatically to fit their contents
 |
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
 |
Step 2: Now click on the "merge cells" button. On the confirmation box, click “Ok” to proceed.
 |
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 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
|
Article Contributed By :
|
|
|
|
|
204 Views |
|