Comments appear when printing

J

Joël

While I asked Excel to show a comment, it doesn't appear when printing
The only way to solve is to create a small text box but it is not linked to
a cell and could be displaced
My question: is there an easy way to make the 'comment' appear when printing ?
Thansk in advance
Joël
 
R

rahrah3a

In File - Page Setup select tab Sheet look for Section Print and "Comments:"
select "As displayed on Sheet" from the drop down box. This will print
comments as they appear on the sheet.
 
D

David Biddulph

Joël said:
While I asked Excel to show a comment, it doesn't appear when printing
The only way to solve is to create a small text box but it is not linked to
a cell and could be displaced
My question: is there an easy way to make the 'comment' appear when
Click to expand...
printing ?

Yes.

File/ Page Setup:
In the "Comments" box select either "At end of sheet" or "As displayed on
sheet".
 
J

Joël

thanks for help !

David Biddulph said:
printing ?

Yes.

File/ Page Setup:
In the "Comments" box select either "At end of sheet" or "As displayed on
sheet".
Click to expand...
 
J

Joël

thanks for help !

rahrah3a said:
In File - Page Setup select tab Sheet look for Section Print and "Comments:"
select "As displayed on Sheet" from the drop down box. This will print
comments as they appear on the sheet.
Click to expand...
 
J

Jeff

In excel 2003, where can I change the default to print comments for all
spreadsheets?
I have changed the sheet.xlt file in xlstart but this does not seem to have
any effect on files that are generated from other applications.
 
G

Gord Dibben

Jeff

You can change the default only for newly created workbooks and sheets, not
existing ones.

Open a new workbook. Customize as you wish.

File>Save As Type: scroll down to Excel Template(*.XLT) and select. Name your
workbook "BOOK"(no quotes). Excel will add the .XLT to save as BOOK.XLT.

Store this workbook in the XLSTART folder usually located at........

C:\Documents and Settings\username\Application Data\Microsoft\Excel\XLSTART

This will be the default workbook for File>New or the Toolbar button File>New or
CTRL + n

WARNING................Do not use File>New...Blank Workbook or you will get the
Excel default workbook.

NOTE: Existing workbooks are not affected by these settings.

You can also open a new workbook and delete all but one sheet. Customize as
you wish then save this as SHEET.XLT in XLSTART folder also. It now becomes
the default Insert>Sheet.

More can be found on this in Help under "templates"(no quotes).


Gord Dibben Excel MVP
 
Top