How can I display the comments when I print in Excel?

E

Excel comments

How can I display the comments when I print in Excel?
I need your help.
Thanks!
 
S

Stefi

File>Page setup>Page tag>Choose appropriate option from Comments drop down
list.

Regards,
Stefi


„Excel comments†ezt írta:
 
E

Excel comments

Sorry ,I can not understand

Stefi said:
File>Page setup>Page tag>Choose appropriate option from Comments drop down
list.

Regards,
Stefi


„Excel comments†ezt írta:
 
S

Stefi

Click on File menu item from menu bar (at the top of Excel window)
Select Page setup from the drop down list
Click on Page tag
Click on down arrow next to Comments field
Select required option

Stefi


„Excel comments†ezt írta:
 
D

David Biddulph

You haven't said which version of Excel you are using, nor has Stefi said
which version she is using. If you type "print comments" into Excel help,
you should get an answer applicable to your version.

For Excel 2003 it is:
"
1. Click the worksheet.
2. 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?]
3. On the File menu, click Page Setup, and then click the Sheet tab.
4. 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.
5. Click Print. "
 
E

Excel comments

Thank you very much!

David Biddulph said:
You haven't said which version of Excel you are using, nor has Stefi said
which version she is using. If you type "print comments" into Excel help,
you should get an answer applicable to your version.

For Excel 2003 it is:
"
1. Click the worksheet.
2. 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?]
3. On the File menu, click Page Setup, and then click the Sheet tab.
4. 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.
5. Click Print. "
--
David Biddulph

Excel comments said:
Sorry,what is mean of ''Click on Page tag ''?
I don't find this item.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top