Unmerge so that the value goes into multiple Cells

M

mg

Is there a way i can unmerge so that the value goes into all of the cells not
just the top left cell?
 
D

Debra Dalgleish

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.
 
Top