All » Google Sheets » How to Merge Cells in Google Sheets

 

How to Merge Cells in Google Sheets

There are a number of reasons you would want to merge cells in Google Sheets.

One reason is that you need to add headings and an image to an instructional sheet such as on this one, which explains how to copy and use a Google Sheet that imports RSS feeds.

Google Sheets Example Merge Cells Horizontally

Merging Google Sheets Cells Horizontally

Here’s how to merge cells horizontally to create a heading. In the instructions below, we explain how to add a heading that’s similar to the one in the above image.

1. Select two cells from the same row.

Google Sheets Select Two Cells

2. From the menus, select Format > Merge cells > Merge horizontally.

Google Sheets Merge Cells Horizontally

3. Key in your text and then center the text.

Google Sheets Center Text

4. Increase the font size.

Google Sheets Increase Font Size

5. Click on the text color tool to change the color of the text to white.

Google Sheets Change Text Color

6. Click on the fill bucket tool to change the fill to a high contrast color. We chose cornflower blue.

Google Sheets Fill Cell Color

7. You will now have a heading that is in horizontally merged cells.

Google Sheets Heading

Merging Google Sheets Cells Vertically

If you want to add an image or a block of text next to a column of numbers, merging cells vertically in your Google Sheet is a good way to do this.

Merge Cells Vertically

To merge cells vertically, select a range of cells from a column. From the menus, select Format > Merge cells > Merge vertically.

Merge Range of Cells

To add an image to the merged cells, select Insert > Image > Insert image in cell. Select an image from Google Drive, your local drive, or search.

Insert Image Into Merged Cells

Alternatively, you can add text to the merged cells. You may need to align the text to the top and also wrap text in the merged cells.

Unmerging Cells

There are times you may want to unmerge merged cells.

Click into the area of the merged cells and then select Format > Merge cells > Unmerge.

 

This site includes affiliate links to a Google Workspace page and associate links to Amazon.com. As an Amazon Associate, I earn from qualifying purchases.

Gmail™, Google Workspace™, Google Sheets™ , Google Docs™ , Google Slides™ , Google Meet™ , Google Drive™, and Google Sites™ are trademarks of Google LLC

#supportukraine