[Year 12 IT Apps] RE: Adding a help option in Excel

[Charles Clarke]

I do use the comments set to pop up when the mouse is run over the relevant cell.  If students are using this feature for their documentation I would ask for a printout of all the comments and their locations.

Two other options are:

1. to use one of the worksheets accessed by the tabs at the bottom of the screen... I use the first one, label it Help, set it to a more noticeable colour and put a note/link to it on the main worksheet. I prefer that to using a separate file as it is too easy for separate files to become separated!

2. you can set up a quicktips cell by putting a list of tips in a column of hidden cells, put an index column next to them (ie 1 to the number of tips),then use a lookup in the quicktips cell that references a random number in the range used in the index column.  The quicktips will refresh each time an entry is made in the spreadsheet data.

I have used a link to a web page on our intranet which has the advantage of being able to be updated independently of the spreadsheet, however as our intranet is in a constant state of flux I have had problems with the link dying so am not using that at present.

Not sure what you mean by changing the headings at the top of each column.. 

Cheers

Charlie

-----Original Message-----
From: itapps-bounces at edulists.com.au on behalf of Kent Beveridge
Sent: Mon 7/16/2007 5:18 PM
To: Year 12 IT Applications Teachers' Mailing List
Subject: Adding a help option in Excel
 
Why not! (comment balloons that is...)
Another option which would be simple to do too would be simply make a word file with comments and whatever else in it and provide a link to that file.
 
If anyone out there can tell me how to change the headings at the top of each column and/or how to create an extra option on the menus, that would 
be perfect (plus then how to access the info of course...). I've been wanting to do this for yonks but still dont know how..talk about frustrating!
 
Kent Beveridge,
I.T. co-ordinator
St. Brigids Catholic Sec. College
Horsham
email.. kbeveridge at stbc.vic.edu.au
 
Wishes and Eggs, one you make and one you break!  A bit like promises....