Take a Guess to Win Windows 10 Pro Key!
previous arrow
next arrow
Slider

How Do You Unmerge Cells Correctly?

Date:2021-8-9 Author:Sandra

Are you serious? Just unmerge cells? Yeah, just unmerge cells.  Isn’t it something that can be done with one click of the mouse?  But what if, after canceling the merge, you still need to fill in all the extra cells with the same content?  Let’s take a look.

How Do You Unmerge Cells Correctly?

After we canceling merge cells, there would show blank cells.

How Do You Unmerge Cells Correctly?

At this time, we just need to select column A and press F5 to open the Go To box. Choose the special option.

How Do You Unmerge Cells Correctly?

Select Blanks and hit OK.

How Do You Unmerge Cells Correctly?

All empty cells have been selected. Go to cell A3 and type “=A2”, then press Ctrl and Enter keys.

How Do You Unmerge Cells Correctly?

We made it. that’s very simple and effective. Let’s call it a day.

How Do You Unmerge Cells Correctly?
Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

Leave a Reply

Your email address will not be published. Required fields are marked *