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.

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

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

Select Blanks and hit OK.

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

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

Leave a Reply