Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
What is the Keyboard Shortcut of Merge and Centre Tool Command | Excel Discussion (Misc queries) |