Invisible Notes

B

brohlfs

Hello everyone.

I'm creating a spreadsheet for some coworkers of mine, some of whom may
not be very familiar with Excel but would need to update the file. I
want to include general notes/tips within the spreadsheet, mostly to do
with editing (for instance, how to wrap text, how to insert line breaks
within a cell, etc.), but I don't want these notes to be visible when
the spreadsheet is printed. I also don't want them to be assigned to
specific cells, if that's avoidable. Is this possible?

Thanks. :)
 
D

Dave Peterson

Put all the notes on a different worksheet.

If you don't want the other users to see those notes, then hide that worksheet.

Format|Sheet|Hide

Just unhide/hide it when you want.
 
S

SPinard

You could try using Comments. They are tied to, but do not occupy,
cells. You'd need to be sure to turn on View | Comments. And they can
be prevented from being printed using File | Page Setup | Sheet |
Comments: (None)

Steve Pinard
 
P

Paul B

brohlfs, another option to display your help topics

http://j-walk.com/ss/excel/tips/tip51.htm


--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
 
B

brohlfs

Everyone's help is greatly appreciated - I'll probably try all three
suggestions to see what works best with everyone. Any other ideas are
still welcome!

Thanks again,

Brianna Rohlfs
 
P

Pete_UK

A variation on the "comments" idea is to use Data | Validation. With
this you can specify an input message, such that when the cursor is put
on that cell the message pops up. Although tied to a particular cell,
you could arrange for these messages to be in column A, for example,
which could be locked in place using Window | Freeze Panes, so that if
your co-workers have difficulty on row 9, they can just click on A9 to
get some context-sensitive help. These messages will not print out, and
you can define your print range to exclude column A.

Hope this helps.

Pete
 
Top