To convert comments


ajaygulati1966   23 May 2009

ajaygulati1966

 1 likes  15 points

| My Other Post

I have a excel file prepared by Junior giving descripttion of Payment and Receipt in Bank on daily basis in three CC accounts.  All the comments are given through " insert comment" command.

Is there any command through which this can be transferred on excel sheet itself. 

Thanks Ajay GUlati

1 Like
avater

PRAVEEN KUMAR (MBA (Finance) B.Com.(P))     02 June 2009

PRAVEEN KUMAR
MBA (Finance) B.Com.(P) 
 187 likes  3383 points

View Profile | My Other Post

you can print the comments. steps are given below :

Click the worksheet.

If you want to print the comments in place on the worksheet, display the comments you want to print.

To display an individual comment, right-click its cell and then click Show Comment on the shortcut menu. To display all comments, click Comments on the View menu. Move and resize any overlapping comments as necessary.

How?

Click the border of the comment box so that handles (sizing handle: One of the small circles or squares that appears at the corners and sides of a selected object. You drag these handles to change the size of the object.) appear:


Do one or more of the following:
To move the comment, drag the border of the comment box.

To change the size, drag the handles on the sides and corners of the comment box.
On the File menu, click Page Setup, and then click the Sheet tab.
Do one of the following:

To print the comments where they appear on the worksheet, click As displayed on sheet in the Comments box.

To print the comments at the end of the sheet, click At end of sheet in the Comments box.

Click Print.

 

avater

Shailesh (accounts & Excel VBA)     03 June 2009

Shailesh
accounts & Excel VBA 
 15 likes  342 points

View Profile | My Other Post

Originally posted by :ajaygulati1966
" I have a excel file prepared by Junior giving descriptttion of Payment and Receipt in Bank on daily basis in three CC accounts.  All the comments are given through " insert comment" command.

Is there any command through which this can be transferred on excel sheet itself. 

Thanks Ajay GUlati
"

 

 

Hi Ajay,

You can download "workbooks navigation" addins from below site to write all the comment list info on other sheet.

http://in.geocities.com/shahshaileshs/

You have to right click on the button "Add Sheet" and select Comment List.

Workbook Navigation

 

 

 

Regards,

Shailesh

 

 


Leave a reply

Your are not logged in . Please login to post replies

Click here to Login / Register  



Popular Discussion


view more »