How to Merge Cells in Google Sheets: A Step-by-Step Guide

Published: November 22, 2023 - 4 min read

Krishna Bheda

One of Google Sheet’s most useful features is the ability to merge cells.

Merging cells allows you to combine multiple cells into a single cell, making it easier to format and organize your data. Whether you’re working on a spreadsheet for personal or professional use, knowing how to merge cells in Google Sheets can save you time and help you create more effective spreadsheets.

Merging Cells in Google Sheets

To merge cells in Google Sheets, you can follow these simple steps:

  1. Select the cells that you want to merge. You can select multiple cells by clicking and dragging your mouse over the cells.
  2. Right-click on the selected cells and click on “Merge cells” from the drop-down menu. Alternatively, you can use the shortcut key “Ctrl + Alt + M” to merge the cells.

The selected cells will be merged into one larger cell. Any text or data in the cells will be combined into the new merged cell.

How to Merge Multiple Cells in Google Sheets

If you want learn how to merge multiple cells in Google Sheets, you can follow these steps:

  1. Select the cells that you want to merge. You can select multiple cells by clicking and dragging your mouse over the cells.
  2. Right-click on the selected cells and click on “Merge cells” from the drop-down menu.
  3. The selected cells will be merged into one larger cell. Any text or data in the cells will be combined into the new merged cell.

It is important to note that when you merge cells in Google Sheets, the data in the cells will be combined into one cell, and any formatting or formulas in the original cells will be lost. Therefore, it is recommended that you only merge cells when necessary and make a backup of your data before merging cells.

Advanced Merging Techniques

Once you have mastered “Merge All” where you merge all selected cells into a single cell, you can dive into the two other merge options available in Google Sheets:

Merge Horizontally: This option will merge the selected cells into a single row.

Merge Vertically: This option will merge the selected cells into a single column.

You can also merge empty cells and unmerge cells.

How to Merge Cells Horizontally

You may want to merge cells horizontally instead of vertically. T

To do this:

  1. Select the cells you want to merge.
  2. Click on the “Merge horizontally” button in the toolbar. 

This will merge the cells into a single cell, with the contents of the leftmost cell being retained.

How to Merge Cells Vertically

You may want to merge cells horizontally instead of vertically. T

spreadsheet ai
Free AI-Powered Tools Right Within Your Spreadsheet

Supercharge your spreadsheets with GPT-powered AI tools for building formulas, charts, pivots, SQL and more. Simple prompts for automatic generation.

To do this:

  1. Select the cells you want to merge.
  2. Click on the “Merge vertically” button in the toolbar.

This will merge the cells into a single vertical cell, with the contents of the topmost cell being retained. If you have several cells arranged in a column and you merge them vertically, the merged cell will display the content from the cell that was at the top of the column before the merge.

How to Merge All Empty Cell in Google sheets 

If you have a large dataset with many empty cells, you can use the “Merge all empty cells” feature to quickly merge all empty cells into a single cell.

To do this:

  1. Select the entire dataset.
  2. Click on the “Merge all empty cells” button in the toolbar. 

This will merge all empty cells into a single cell, making it easier to work with the data.

How to Unmerge Cells 

If you need to unmerge cells in Google Sheets, you can do so by:

  1. Selecting the merged cell.
  2. Clicking “Format” > “Merge Cells” > “Unmerge”.

Keep in mind that if the cells you previously merged all contained information in them, none of the data that was previously there will be preserved.

In conclusion, merging cells in Google Sheets is a simple process that can help you keep your data organized and easy to read. By following this step-by-step guide, you can merge cells with ease and unmerge them if needed.

Set Spreadsheet Data on Refresh

Try the Spreadsheet Automation Tool Over 300,000 Professionals are Raving About

Tired of spending endless hours manually pushing and pulling data into Google Sheets? Say goodbye to repetitive tasks and hello to efficiency with Coefficient, the leading spreadsheet automation tool trusted by over 300,000 professionals worldwide.

Sync data from your CRM, database, ads platforms, and more into Google Sheets in just a few clicks. Set it on a refresh schedule. And, use AI to write formulas and SQL, or build charts and pivots.

Krishna Bheda Growth Marketer
Krishna Bheda is a growth marketer passionate about B2B SaaS and PLG. Specifically, Coefficient's ability to automate data and empower individuals to accelerate analyses and strategy, hits close to home. With a background in Economics and Statistics, working in the data space is a dream.
Google icon
300,000+ users on Google Marketplace
Wait, there's more!
Connect any system to Google Sheets in just seconds.
Get Started Free

Trusted By Over 20,000 Companies