Retain value of merged cell in all unmerged cells

K

kari

I have a table with a column of data that has merged cells with a value in
it, I would like to unmerge the cells, but retain the value of the cell in
all of the unmerged cells instead of only the top cell. Is there a way or
macro to do this?
 
P

Pete_UK

After unmerging, highlight all the cells in that column in your table,
then press F5 (GoTo) and click on Special, then on blanks - you should
see only the blank (unmerged) cells highlighted. Then begin to type a
formula by entering = and then click on the cell immediately above the
first cell that is selected and then CTRL-ENTER. Now you can fix the
values in that column using <copy> and Edit | Paste Special | Values.

Hope this helps.

Pete
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Automatically color merged cells 1
Document Merge Formatting Issue 0
Sorting Multiple Tables 1
Form problems in a table with merged cells 0
Merged Cells 0
Form command not working on worksheet with merged cells 0
Sharing workbooks limitations - Merged Cells 12
Word macro that can call cells out of Excel for a find and replace 0

Top