How to Unmerge Cells in Google Sheets: Step-by-Step Guide

Unmerging cells in Google Sheets is a pretty straightforward process. Simply highlight the merged cell you want to separate, right-click to open the context menu, and select “Unmerge cells”. Voila! You’re back to having individual cells. This action can be particularly useful when you need to reorganize data or make changes to your spreadsheet layout.

After you unmerge cells, each piece of content that was in the merged cell will appear in the top-left cell of the unmerged area. Any formatting applied to the merged cell will also apply only to this top-left cell.


Merging cells in Google Sheets can be a great way to make your data stand out and create a clean, organized look in your spreadsheets. But what happens when you need to revert that action? Maybe you made a mistake, or perhaps the data needs to be reorganized. This is where unmerging cells comes into play. It’s a simple yet essential functionality that can save you from the hassle of manually re-entering data into individual cells.

Unmerging cells is relevant to anyone using Google Sheets for data management, whether you’re a student keeping track of your study schedule, a small business owner managing your inventory, or an office worker analyzing monthly sales data. Understanding how to unmerge cells ensures you maintain flexibility and control over your spreadsheet’s design and content. So, let’s dive into the step-by-step process of unmerging cells in Google Sheets.

Related: How to Make a Header Row in Google Sheets: A Step-by-Step Guide

Step by Step Tutorial: Unmerging Cells in Google Sheets

Before we get into the nitty-gritty, it’s important to understand that unmerging cells will spread out the content over the cells that were merged. This means you might have to do a bit of data cleanup afterward, but it’s nothing to worry about. Let’s get started.

Step 1: Select the merged cell

Click on the merged cell that you want to unmerge.

When you select the merged cell, you’ll notice that it covers multiple rows and/or columns. This is the area that will be affected when you unmerge.

Step 2: Right-click to open the context menu

Right-click on the selected merged cell to open the context menu.

The context menu is where you’ll find various options for cell formatting, including the unmerge option.

Step 3: Click on “Unmerge cells”

In the context menu, find and click on the “Unmerge cells” option.

Once you click “Unmerge cells”, the cells will immediately separate, and the content will only remain in the top-left cell.


Restores individual cell functionalityUnmerging cells allows you to edit, format, and use each cell independently, which is crucial for detailed data management.
Easy to performThe process of unmerging cells is user-friendly and can be done in just a few clicks, making it accessible for users of all skill levels.
Maintains top-left cell contentThe content of the merged cell isn’t lost; it simply defaults to the top-left cell, ensuring no data is accidentally deleted during the process.


Potential data cleanupAfter unmerging, you may need to redistribute content across the cells, which could require some manual work.
Formatting adjustmentsThe format of the merged cell will apply only to the top-left cell, possibly requiring you to reformat the newly unmerged cells.
Confusion with large mergesIf you have a large merged cell, unmerging could lead to confusion about which data belongs in which cell, necessitating careful review.

Additional Information

Unmerging cells in Google Sheets can be a blessing when you’re restructuring data or fixing mistakes. However, it’s important to consider the layout of your spreadsheet and the potential need for reformatting after unmerging. For instance, if you had a title spanning across multiple columns, unmerging will leave the title in the leftmost cell, and you’ll need to adjust the text alignment or merge different cells to maintain the aesthetic.

Remember, the “Undo” function (Ctrl/Cmd + Z) is your friend. If you unmerge cells and immediately regret it, a quick undo can save you the trouble of manually merging them again. Also, it’s worth mentioning that Google Sheets has a “Merge across” option that might come in handy if you’re looking to merge cells only across rows and not columns.

Lastly, let’s not forget about shortcuts. While there isn’t a direct keyboard shortcut for unmerging cells, learning other Google Sheets shortcuts can streamline your workflow and make cell management more efficient.


  1. Select the merged cell
  2. Right-click to open the context menu
  3. Click on “Unmerge cells”

Frequently Asked Questions

What happens to the data in the merged cells after unmerging?

The data that was in the merged cell will appear in the top-left cell of the unmerged range.

Can I unmerge multiple merged cells at once?

Yes, you can select multiple merged cells or even a range containing merged cells and unmerge them all in one go.

Will unmerging cells affect the formatting of my spreadsheet?

The formatting applied to the merged cell will remain on the top-left cell after unmerging, so you might need to adjust formatting for the other cells.

Is there an undo option if I make a mistake while unmerging cells?

Absolutely, you can always use the “Undo” function (Ctrl/Cmd + Z) to revert the unmerge action.

Can I use keyboard shortcuts to unmerge cells in Google Sheets?

There’s no direct shortcut for unmerging, but you can use keyboard navigation and the context menu key on your keyboard to access the unmerge option.


Whether you’re a seasoned spreadsheet jockey or a casual user, knowing how to unmerge cells in Google Sheets is a skill that can come in handy more often than you’d think. It’s a simple process that can have a significant impact on how you present and work with data.

As always, the key to spreadsheet mastery is practice and exploration, so don’t be afraid to dive in and play around with merging and unmerging cells to see how it affects your data organization. Remember, the undo button is just a keystroke away if you need it. Now go forth and conquer those cells like the spreadsheet wizard you are!