close

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.

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()