Unmerge so that the value goes into multiple Cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way i can unmerge so that the value goes into all of the cells not
just the top left cell?
 
Select the merged cell
Choose Format>Cells
On the Alignment tab, remove the check mark from Merge cells
Click OK
With all the unmerged cells still selected, click in the formula bar
Hold the Ctrl key and press the Enter key.
 
You must log in or register to reply here.

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

drag down, not by series 4
Unmerging and populating merged cells by column 3
Retain value of merged cell in all unmerged cells 3
Cannot copy the merge cells into another sheet 5
Protected sheet - attempt to delete row = unmerged cells 5
Expanding merged cells 3
Unable to unmerge/merge cells 4
PasteSpecial method of Range class failed 4

Back
Top