How to Unmerge Cells in Google Docs Spreadsheets

Click on the cell that you want to unmerge., Click the arrow next to the Merge button., Select "Unmerge" from the drop down menu., Verify that your cells have been reverted.

4 Steps 1 min read Easy

Step-by-Step Guide

  1. Step 1: Click on the cell that you want to unmerge.

    You can only unmerge cells that have previously been merged together.
  2. Step 2: Click the arrow next to the Merge button.

    This is located between the Borders and Alignment buttons.

    The down arrow will open a small Merge menu. , This will revert the cells to their original individual cells.

    Any data in the merged cell will be placed in the first of the unmerged cells. , You should see distinct cells after performing the Unmerge command.

    If you do not, ensure that you have the correct cell selected when using the Unmerge command.
  3. Step 3: Select "Unmerge" from the drop down menu.

  4. Step 4: Verify that your cells have been reverted.

Detailed Guide

You can only unmerge cells that have previously been merged together.

This is located between the Borders and Alignment buttons.

The down arrow will open a small Merge menu. , This will revert the cells to their original individual cells.

Any data in the merged cell will be placed in the first of the unmerged cells. , You should see distinct cells after performing the Unmerge command.

If you do not, ensure that you have the correct cell selected when using the Unmerge command.

About the Author

G

Grace Jackson

Grace Jackson specializes in education and learning and has been creating helpful content for over 4 years. Grace is committed to helping readers learn new skills and improve their lives.

30 articles
View all articles

Rate This Guide

--
Loading...
5
0
4
0
3
0
2
0
1
0

How helpful was this guide? Click to rate: