close

I am looking at an excel worksheet that was sent to me. There are several
comments on the sheet. One of the cells is too small and I cannot read
everything that is in the comment box. How can I make this box bigger so that
I can see the entire contents

quot;Shelquot; wrote:
gt; I am looking at an excel worksheet that was sent to me. There are several
gt; comments on the sheet. One of the cells is too small and I cannot read
gt; everything that is in the comment box. How can I make this box bigger so that
gt; I can see the entire contents

Right-click on the cell gt; Edit Comment
Then just drag the bottom right corner of the comment box
diagonally down to enlarge the comment box
--
Max
Singapore
savefile.com/projects/236895
xdemechanik
---



quot;Maxquot; wrote:

gt; quot;Shelquot; wrote:
gt; gt; I am looking at an excel worksheet that was sent to me. There are several
gt; gt; comments on the sheet. One of the cells is too small and I cannot read
gt; gt; everything that is in the comment box. How can I make this box bigger so that
gt; gt; I can see the entire contents
gt;
gt; Right-click on the cell gt; Edit Comment
gt; Then just drag the bottom right corner of the comment box
gt; diagonally down to enlarge the comment box
gt; --
gt; Max
gt; Singapore
gt; savefile.com/projects/236895
gt; xdemechanik
gt; ---

Thanks. I tried this, but I when I right click on the cell I don't have the
option to edit comment. I am thinking that this is because the worksheet is
password protected.

quot;Shelquot; wrote:
gt; Thanks. I tried this, but I when I right click on the cell I don't have the
gt; option to edit comment. I am thinking that this is because the worksheet is
gt; password protected.

Other than stating the obvious*, afraid I'm out of further ideas here
*unprotect the sheet / ask the book's author to resize that comment box

--
Max
Singapore
savefile.com/projects/236895
xdemechanik
---

Thanks for the help!
I was hoping I could just do it on my own w/o having to bother the author.

quot;Maxquot; wrote:

gt; quot;Shelquot; wrote:
gt; gt; Thanks. I tried this, but I when I right click on the cell I don't have the
gt; gt; option to edit comment. I am thinking that this is because the worksheet is
gt; gt; password protected.
gt;
gt; Other than stating the obvious*, afraid I'm out of further ideas here
gt; *unprotect the sheet / ask the book's author to resize that comment box
gt;
gt; --
gt; Max
gt; Singapore
gt; savefile.com/projects/236895
gt; xdemechanik
gt; ---

A non permanent option, assuming the protection allows it, would be to
increase the zoom factor.

Shel wrote:
gt; Thanks for the help!
gt; I was hoping I could just do it on my own w/o having to bother the author.
gt;
gt; quot;Maxquot; wrote:
gt;
gt;
gt;gt;quot;Shelquot; wrote:
gt;gt;
gt;gt;gt;Thanks. I tried this, but I when I right click on the cell I don't have the
gt;gt;gt;option to edit comment. I am thinking that this is because the worksheet is
gt;gt;gt;password protected.
gt;gt;
gt;gt;Other than stating the obvious*, afraid I'm out of further ideas here
gt;gt;*unprotect the sheet / ask the book's author to resize that comment box
gt;gt;
gt;gt;--
gt;gt;Max
gt;gt;Singapore
gt;gt;savefile.com/projects/236895
gt;gt;xdemechanik
gt;gt;---

--

Andy Pope, Microsoft MVP - Excel
www.andypope.info

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

    software

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