Thread: Merge
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default Merge

Firstly, please find the Caps Lock key and stop SHOUTING.

Secondly, select the cells, then Format/ Cells/ Alignment:
Unselect "Merge cells".

Having unmerged the cells, you can copy what you want where you want it.
--
David Biddulph

"EMAD" wrote in message
...
I HAVE A MERGED CELL AND I WANT TO UNMERGED IT AND TO COPY THE DATA THAT
WAS
IN THE MERGED CELL TO THE CELLS THAT HAVE BEEN UNMERGED(I HOPE THAT YOU
UNDERSTAND ME)


AND THANK YOU FOR YOUR TIME