How to Quickly Merge Cells in Google Sheets

Watch Video – Merge Cells in Google Sheets

When you work with data that has headers, sometimes, you may feel the need to merge cells in Google Sheets.

For example, if you have the main header as Revenue and subheaders as 2016, 2017, and 2018, you can merge the three cells that make up the revenue header.

Something as shown below:

Merge Cells in Google Sheets - Dataset

As you can see in the example above, Revenue spans across three cells that have been merged.

Steps to Merge Cells in Google Sheets

Here are the steps to merge cells in Google Sheets:

  • Select the cells that you want to merge.
  • Go to the Format tab and within the Merge Cells options select Merge All.

That’s it!

This would instantly merge all the selected cells and make it one.

Note: When you merge cells, it only retains the value in the top left cell. If there is anything in cells apart from the top left cells, Google Sheets shows you the prompt as shown below.

Now also have a look at the merge cells options available in Google Sheet:

  • Merge All: This would merge all the selected cells and make it one. Note that you can only have contiguous cells that can be combined. If you have non-contiguous cells, merge options will not be available to use.Merge Cells in Google Sheets - Merge All
  • Merge Horizontally: This would merge all the horizontal cells into one. Even when you select more than one row of cells, it will only merge the horizontal cells.Merge Cells in Google Sheets - Merge Horizontally
  • Merge Vertically: This would merge all the vertical cells into one. Even when you select more than one column of cells, it will only merge the vertical cells.Merge Cells in Google Sheets - Merge Vertically

Steps to Unmerge Cells in Google Sheets

Here are the steps to unmerge cells in Google Sheets:

  • Select the merged cells that you want to unmerge.
  • Go to the Format tab and within the Merge Cells options select Unmerge.

This would instantly unmerge all the merged cells in Google Sheets.

Also Read: How to Merge Cells in Excel.

You May Also Like the following Google Sheets Tutorials:

FREE EBOOK - GOOGLE SHEETS TIPS

10 Google Sheets Tips that will save you hours every week

1 Star2 Stars3 Stars4 Stars5 Stars (2 votes, average: 5.00 out of 5)
Loading...
Bar Sparkline in Google Sheets - rtl
Google Sheets

Sparkline in Google Sheets – The Only Guide You Need

Sparklines are miniature charts that you can create within a cell. These are quite useful when you’re creating a dashboard and want to quickly show a trend, seasonal increase or decrease, or outliers (maximum/minimum) visually. According

Google Sheets

How to Insert Timestamp in Google Sheets

Google Sheets is a great tool when you’re collaborating and working with people on the same sheet. It allows people to work in the sheet simultaneously. In this tutorial, you’ll learn various to insert timestamp in Google

Google Sheets Keyboard Shortcuts - Spreadsheets
Google Sheets

101 Google Sheets Keyboard Shortcuts

Google Sheets is a relatively new spreadsheet tool in the market. It has quickly gained a lot of fan following and I see a lot of people migrating from other spreadsheets applications to Google Sheets.

>