How To Merge Cells In Google Sheets

How To Articles

Have you ever needed to merge cells in Google Sheets to create a cleaner layout or to combine the content of multiple cells into one? I’m here to show you the ins and outs of merging cells in Google Sheets, so you can take your spreadsheet skills to the next level!

What is Merging Cells?

When you merge cells in Google Sheets, you combine two or more adjacent cells into a single, larger cell. The content of the merged cells is placed in the upper-leftmost cell, and the rest of the cells become empty. This can be useful for creating headers, subheadings, or simply for a more visually appealing layout.

How to Merge Cells in Google Sheets:

  1. Select the range of cells you want to merge. You can do this by clicking and dragging your mouse over the cells, or by clicking on the first cell and then holding down the Shift key while clicking on the last cell in the range.
  2. Once you have the cells selected, go to the “Format” menu at the top of the page.
  3. Hover over “Merge cells” in the dropdown menu, and select either “Merge all” to merge all the selected cells, or “Merge horizontally” or “Merge vertically” to merge the cells in a specific direction.
  4. That’s it! Your cells are now merged.

Considerations When Merging Cells:

While merging cells can be a helpful tool, there are a few things to keep in mind:

  1. Merged cells can affect the functionality of certain Google Sheets features, like sorting and filtering. Be mindful of this when using merged cells in a spreadsheet that requires these functions.
  2. If you need to unmerge cells, you can do so by selecting the merged cell, going to the “Format” menu, hovering over “Merge cells,” and then selecting “Unmerge.”
  3. Be cautious when merging cells with data, as merging will discard all but the content from the top-left cell. Make sure you won’t lose any important information when merging cells.

My Personal Take on Merging Cells:

Merging cells is a handy feature in Google Sheets, but I’ve found that it’s important to use it sparingly. While it can create a cleaner and more organized appearance, it’s crucial to consider the impact it may have on the functionality of your spreadsheet. In my experience, I often use merged cells for creating clear headers or for aesthetic purposes in presentation sheets, but I tend to avoid them in spreadsheets where sorting and filtering are crucial. As with any tool, it’s all about using it judiciously and understanding its implications.


Now that you’ve mastered the art of merging cells in Google Sheets, you have a powerful tool at your disposal for creating polished and visually appealing spreadsheets. Just remember to use it thoughtfully and consider how merging cells may impact the functionality of your spreadsheet. Happy merging!