undue merge and centre

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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 :-)
------------------------------­------------------------------­----------------
 
Undue?
Click the merged cells,
Format > Cells > Alignment, uncheck 'Merge cells'.

Hope this helps.

George Gee
 
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
 
Back
Top