How to Unmerge Cells in Google Sheets

Sanskar Tiwari

Author: Sanskar Tiwari

Founder at MagicSlides

Published

Easily learn how to unmerge cells in Google Sheets to regain control of individual cell formatting

How to Unmerge Cells in Google Sheets

Merging cells in Google Sheets is a great way to organize data, especially for headers or formatting.
However, there are times when you need to reverse the action and unmerge those cells to regain access to the individual cells. Fortunately, Google Sheets makes it easy to unmerge with just a few clicks.
Whether you’re cleaning up a shared spreadsheet or adjusting a layout, this step-by-step tutorial will help you unmerge any group of cells quickly and correctly without affecting your data.

Step-by-Step Guide to Unmerge Cells

Step 1: Open Your Google Sheets File

Go to Google Sheets and open the file where you want to unmerge cells.
notion image

Step 2: Select the Merged Cell

Click on the cell or range of cells that are currently merged. Merged cells will show centered content across the merged range.
notion image

Step 3: Use the Toolbar Option

  • In the top toolbar, click on the Merge cells icon (it looks like two rectangles merging).
notion image
  • Then, choose Unmerge from the dropdown.

Step 4: Alternative via Format Menu

  • Click on the Format tab in the top menu.
  • Hover over Merge cells, then select Unmerge from the side menu.

Step 5: Verify

The content will remain in the top-left cell of the range, and the merged area will now be separated into individual cells.

Tired of spending hours cleaning data or writing complex formulas? Here’s a smarter solution: SheetAI.app

Whether you're managing sales reports, crafting marketing content, or analyzing feedback, working in spreadsheets can be time-consuming and repetitive. But what if you could automate these tasks and enhance your productivity directly within Google Sheets? That's exactly what SheetAI offers.
notion image
SheetAI is an AI-powered add-on for Google Sheets that brings advanced capabilities right into your spreadsheet. Simply describe what you want in plain English, and SheetAI will execute tasks such as generating formulas, cleaning data, summarizing text, and even creating images. (SheetAI Documentation - AI-Powered Functions for Google Sheets)
Here’s what you’ll love about SheetAI:
  • Natural Language Commands: Use plain English to perform complex tasks.
  • AI-Powered Functions: Leverage functions like =SHEETAI() and =SHEETAI_RANGE() for dynamic content generation.
  • Data Cleaning & Analysis: Automate data sanitization, summarization, and categorization.
  • Content Generation: Create blog ideas, product descriptions, and personalized messages effortlessly.
  • Image Creation: Generate images directly within your spreadsheet using =SHEETAI_IMAGE().
  • Formula Generation: Convert textual descriptions into accurate Google Sheets formulas.
  • Integration with AI Models: Supports GPT-3, GPT-4, Claude, and Gemini for versatile AI capabilities.
Perfect for marketers, analysts, educators, and anyone looking to enhance their spreadsheet workflows.
Ready to revolutionize your Google Sheets experience? Install SheetAI now and start automating your tasks with AI!

Conclusion

Unmerging cells in Google Sheets is a simple and essential skill when working with structured data.
Whether you need to edit individual cells or reformat your spreadsheet, this feature helps restore flexibility to your layout.
Mastering it will make managing your sheets smoother and more efficient.

FAQs are here to guide!

Will I lose my data after unmerging cells?

No, the content will stay in the top-left cell of the merged area.

Can I unmerge multiple merged cells at once?

Yes, you can select multiple merged cells and unmerge them all at the same time.

How do I know if a cell is merged?

Merged cells usually have centered content and span across multiple columns or rows.

Can I undo an unmerge?

Yes! Just press Ctrl + Z or go to Edit > Undo immediately after unmerging.

Share on socials