Format / Cells..... uncheck the merge option. Hit left Align and then redo
it all with your desired range.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------


"ED" wrote in message
...
I am trying to undue the "merge and centre" of my title. I would like to
make the range smaller.
Is this possible?
Thank you.