View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Jeff Jeff is offline
external usenet poster
 
Posts: 921
Default Comments appear when printing

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.

"rahrah3a" wrote:

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.

"Joël" wrote:

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