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.

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" <[email protected]> wrote in message
news:[email protected]...
>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?
Click the merged cells,
Format > Cells > Alignment, uncheck 'Merge cells'.

Hope this helps.

George Gee





"ED" <[email protected]> wrote in message
news:[email protected]...
>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.

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.