Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / January 2006

Tip: Looking for answers? Try searching our database.

Invisible Notes

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
brohlfs - 11 Jan 2006 18:44 GMT
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. :)

Signature

brohlfs

Dave Peterson - 11 Jan 2006 19:06 GMT
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.

> Hello everyone.
>
[quoted text clipped - 13 lines]
> brohlfs's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=30373
> View this thread: http://www.excelforum.com/showthread.php?threadid=500316

Signature

Dave Peterson

SPinard - 11 Jan 2006 20:22 GMT
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
Paul B - 11 Jan 2006 20:35 GMT
brohlfs, another option to display your help topics

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

Signature

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

> Hello everyone.
>
[quoted text clipped - 7 lines]
>
> Thanks. :)
brohlfs - 11 Jan 2006 21:00 GMT
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

Signature

brohlfs

Pete_UK - 12 Jan 2006 00:22 GMT
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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.