undue merge and centre

[Guest]

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.

 

[Ken Wright]

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
------------------------------­------------------------------­----------------

 

[George Gee]

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

Hope this helps.

George Gee

 

[Guest]

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