E
ED
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.
make the range smaller.
Is this possible?
Thank you.
K
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
----------------------------------------------------------------------------
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
----------------------------------------------------------------------------
G
George Gee
Undue?
Click the merged cells,
Format > Cells > Alignment, uncheck 'Merge cells'.
Hope this helps.
George Gee
Click the merged cells,
Format > Cells > Alignment, uncheck 'Merge cells'.
Hope this helps.
George Gee
E
Elkar
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
"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