Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Shel
 
Posts: n/a
Default how do I make an excel comment box bigger?

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
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max
 
Posts: n/a
Default how do I make an excel comment box bigger?

"Shel" wrote:
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


Right-click on the cell Edit Comment
Then just drag the bottom right corner of the comment box
diagonally down to enlarge the comment box
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Shel
 
Posts: n/a
Default how do I make an excel comment box bigger?



"Max" wrote:

"Shel" wrote:
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


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


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.
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max
 
Posts: n/a
Default how do I make an excel comment box bigger?

"Shel" wrote:
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.


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
http://savefile.com/projects/236895
xdemechanik
---
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Shel
 
Posts: n/a
Default how do I make an excel comment box bigger?

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

"Max" wrote:

"Shel" wrote:
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.


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
http://savefile.com/projects/236895
xdemechanik
---



  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Andy Pope
 
Posts: n/a
Default how do I make an excel comment box bigger?

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

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

"Max" wrote:


"Shel" wrote:

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.


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
http://savefile.com/projects/236895
xdemechanik
---


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Multiple Excel versions. Naveen Mukkelli Excel Discussion (Misc queries) 0 May 16th 06 12:55 AM
"red" Triangle in Comment Indicator- make bigger?? MikeR-Oz New Users to Excel 3 April 7th 06 09:29 AM
How to make Excel 2003, not IE 6, open Excel files from a web? Dmitry Excel Discussion (Misc queries) 2 March 23rd 06 02:01 PM
How do I make at boxplot in Excel? MM Excel Discussion (Misc queries) 1 March 19th 06 02:55 PM
I'd like to use Excel to make changes to an HTML document... Jola Excel Discussion (Misc queries) 2 March 7th 06 02:29 PM


All times are GMT +1. The time now is 03:33 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"