notes

  • Thread starter Thread starter ADK
  • Start date Start date
A

ADK

I would like to place instructions on how to enter data into the sheet,
placing the instruction notes off to the side ...but do not want to have
these notes printable.

Is this possible? any other suggestions?

I am using Microsoft Excel 2000

Thanks
 
Maybe you could add a textbox (either from the control toolbox toolbar or from
the Drawing toolbar). Then right click and choose "format object" or "format
text box".

There's a property tab where you can specify to print or not to print.

Or maybe you could just define your printrange
file|print area|set print area

and exclude those cells with the notes.
 
Maybe you should think about Data (menu) | Validation. It has an Input
(tab) that will allow you to specify the text, so that when the cell is
selected, a small window will pop up with your specified text in it
(generally used as directions or helpful tips) and they are not printable.

Also, you can use cell comments and make them not printable, but the mouse
cursor must be positioned over the cell for it to pop up (if set that way);
you can set it to be there all the time, but (imho) it can get bothersome
and in the way.

HTH
 
thanks

Dave Peterson said:
Maybe you could add a textbox (either from the control toolbox toolbar or
from
the Drawing toolbar). Then right click and choose "format object" or
"format
text box".

There's a property tab where you can specify to print or not to print.

Or maybe you could just define your printrange
file|print area|set print area

and exclude those cells with the notes.
Click to expand...
 
thanks

Zack Barresse said:
Maybe you should think about Data (menu) | Validation. It has an Input
(tab) that will allow you to specify the text, so that when the cell is
selected, a small window will pop up with your specified text in it
(generally used as directions or helpful tips) and they are not printable.

Also, you can use cell comments and make them not printable, but the mouse
cursor must be positioned over the cell for it to pop up (if set that
way);
you can set it to be there all the time, but (imho) it can get bothersome
and in the way.

HTH
Click to expand...
 
Back
Top