I am trying to undue the quot;merge and centrequot; 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 :-)
------------------------------*------------------------------*----------------quot;EDquot; gt; wrote in message
news
gt;I am trying to undue the quot;merge and centrequot; of my title. I would like to
gt; make the range smaller.
gt; Is this possible?
gt; Thank you.
Undue?
Click the merged cells,
Format gt; Cells gt; Alignment, uncheck 'Merge cells'.
Hope this helps.
George Geequot;EDquot; gt; wrote in message
news
gt;I am trying to undue the quot;merge and centrequot; of my title. I would like to
gt; make the range smaller.
gt; Is this possible?
gt; Thank you.
There should be a button on your Formatting Toolbar for this, next to the
quot;RIGHT-CENTER-LEFTquot; 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 quot;Format Cellsquot; (or select Cells from the Format menu)
Click on the quot;Alignmentquot; tab
Uncheck the box for quot;Merge Cellsquot;
Click OK
HTH,
Elkarquot;EDquot; wrote:
gt; I am trying to undue the quot;merge and centrequot; of my title. I would like to
gt; make the range smaller.
gt; Is this possible?
gt; Thank you.
- Mar 09 Fri 2007 20:36
undue merge and centre
close
全站熱搜
留言列表
發表留言