ExcelBanter - Merge

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Merge (https://www.excelbanter.com/excel-discussion-misc-queries/148149-merge.html)

EMAD

Merge

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

David Biddulph[_2_]

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

All times are GMT +1. The time now is 06:48 AM.