Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Claire
 
Posts: n/a
Default I want to show all comments on cells in one cell in the worksheet

Hi
I have a worksheet with lots of comments and I want to be able to view them
in the worksheet like in a summary cell. Is it possible to create this
summary cell?

Cheers

Claire
  #2   Report Post  
virendra.telkar
 
Posts: n/a
Default


Hi,

we cannot make visible all comments in one cell.

although if you want to look at the comment in individual cell , go to
Tools Option View , here are three selection available

1- not to see any of the comments choose -None
2-to pop up the comment when you move cursor on cell which contains
comment -comment indicator only

3-in the third option -comment & indicator the comment will be seen on
the screen itself ( here it will not pop up but be static )

in case u want to print all comments of the sheet,

go to page setup sheet here u will get comments to be displayed as
per the option u select,
1- none
2-at the end of the sheet
3-as displayed on the screen..


in case u need further help u may please mail me on


thanks,

virendra


--
virendra.telkar
------------------------------------------------------------------------
virendra.telkar's Profile:
http://www.excelforum.com/member.php...o&userid=24275
View this thread: http://www.excelforum.com/showthread...hreadid=379827

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
Conditional Cell Shading (based on the shading of other cells) Tubby Excel Worksheet Functions 2 June 20th 06 10:03 PM
show comments when cell is highlighted Vs when cursor runs over? don Excel Discussion (Misc queries) 0 April 30th 05 10:22 AM
GET.CELL Biff Excel Worksheet Functions 2 November 24th 04 07:16 PM
help to show formart in reference cell jiang Excel Worksheet Functions 4 November 23rd 04 03:29 PM
Using the results from two seperate cells to create cell reference DarrenWood Excel Worksheet Functions 2 November 14th 04 10:35 PM


All times are GMT +1. The time now is 10:54 PM.

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

About Us

"It's about Microsoft Excel"