undue merge and centre
 

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.

undue merge and centre
 

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.

undue merge and centre
 

Undue?
Click the merged cells,
Format Cells Alignment, uncheck 'Merge cells'.

Hope this helps.

George Gee





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

undue merge and centre
 

There should be a button on your Formatting Toolbar for this, next to the
"RIGHT-CENTER-LEFT" alignment buttons. Older versions of Excel did not have
this button by default, so if its not there, then you can do this:

Select your merged cell
Right-click and select "Format Cells" (or select Cells from the Format menu)
Click on the "Alignment" tab
Uncheck the box for "Merge Cells"
Click OK

HTH,
Elkar


"ED" wrote:

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.