Hi
I would like to include some "help/hints" on my spreadsheet, explaining to
customers what they need to fill out in various cells, but I don't want the
hints to print out or remain static on the spreadsheet.

eg: when they hover the mouse over a blank cell, the hint might be "type the
despatch week number you require your order to be despatched in Cell A3"

I did this in word over 10 yrs ago and have long forgotten how to, so assume
it can be done Excel - but I am not sure "what" to search for in the help
section?

any suggestions welcome

thanks Sue

Maybe you can use Insert|Comment so that a note shows up when the user mouses
over that cell.

Or maybe you can use data|validation (with no rules), but with an input message
(another tab on that data|validation dialog) that shows up when the cell is
selected.

You may want to use another worksheet that has all your notes on how to use the
workbook, too.

working wrote:

Hi
I would like to include some "help/hints" on my spreadsheet, explaining to
customers what they need to fill out in various cells, but I don't want the
hints to print out or remain static on the spreadsheet.

eg: when they hover the mouse over a blank cell, the hint might be "type the
despatch week number you require your order to be despatched in Cell A3"

I did this in word over 10 yrs ago and have long forgotten how to, so assume
it can be done Excel - but I am not sure "what" to search for in the help
section?

any suggestions welcome

thanks Sue

--

Dave Peterson

InsertComment will provide a message that a hoiver will pop-up.

You can choose to not print Comments when you print.

In fact that is the default.

Data Validation Input Message for another although you have to click on cell to
get the pop-up message.

The advantage of DV is you can limit the users' input to your specs.

Again, these won't print.


Gord Dibben MS Excel MVP


On Tue, 24 Jul 2007 17:18:00 -0700, working
wrote:

Hi
I would like to include some "help/hints" on my spreadsheet, explaining to
customers what they need to fill out in various cells, but I don't want the
hints to print out or remain static on the spreadsheet.

eg: when they hover the mouse over a blank cell, the hint might be "type the
despatch week number you require your order to be despatched in Cell A3"

I did this in word over 10 yrs ago and have long forgotten how to, so assume
it can be done Excel - but I am not sure "what" to search for in the help
section?

any suggestions welcome

thanks Sue

Hi Dave

firstly thanks for being so prompt, I will go with the insert Comment option.
thanks again
Sue

"Dave Peterson" wrote:

Maybe you can use Insert|Comment so that a note shows up when the user mouses
over that cell.

Or maybe you can use data|validation (with no rules), but with an input message
(another tab on that data|validation dialog) that shows up when the cell is
selected.

You may want to use another worksheet that has all your notes on how to use the
workbook, too.

working wrote:

Hi
I would like to include some "help/hints" on my spreadsheet, explaining to
customers what they need to fill out in various cells, but I don't want the
hints to print out or remain static on the spreadsheet.

eg: when they hover the mouse over a blank cell, the hint might be "type the
despatch week number you require your order to be despatched in Cell A3"

I did this in word over 10 yrs ago and have long forgotten how to, so assume
it can be done Excel - but I am not sure "what" to search for in the help
section?

any suggestions welcome

thanks Sue

--

Dave Peterson

thanks Gord

I will go with the insert comments for this one, as no data has to be
specific eg: numeral vs text etc, but I will look up the other option for
future use!

thanks
Sue

"Gord Dibben" wrote:

InsertComment will provide a message that a hoiver will pop-up.

You can choose to not print Comments when you print.

In fact that is the default.

Data Validation Input Message for another although you have to click on cell to
get the pop-up message.

The advantage of DV is you can limit the users' input to your specs.

Again, these won't print.


Gord Dibben MS Excel MVP


On Tue, 24 Jul 2007 17:18:00 -0700, working
wrote:

Hi
I would like to include some "help/hints" on my spreadsheet, explaining to
customers what they need to fill out in various cells, but I don't want the
hints to print out or remain static on the spreadsheet.

eg: when they hover the mouse over a blank cell, the hint might be "type the
despatch week number you require your order to be despatched in Cell A3"

I did this in word over 10 yrs ago and have long forgotten how to, so assume
it can be done Excel - but I am not sure "what" to search for in the help
section?

any suggestions welcome

thanks Sue

Hi Gord

I think I will use the insert comment for this one, as no data is specific
eg: numeral vs text etc. I amgoing to look up the help on the DV for future
use.

thanks
Sue

"Gord Dibben" wrote:

InsertComment will provide a message that a hoiver will pop-up.

You can choose to not print Comments when you print.

In fact that is the default.

Data Validation Input Message for another although you have to click on cell to
get the pop-up message.

The advantage of DV is you can limit the users' input to your specs.

Again, these won't print.


Gord Dibben MS Excel MVP


On Tue, 24 Jul 2007 17:18:00 -0700, working
wrote:

Hi
I would like to include some "help/hints" on my spreadsheet, explaining to
customers what they need to fill out in various cells, but I don't want the
hints to print out or remain static on the spreadsheet.

eg: when they hover the mouse over a blank cell, the hint might be "type the
despatch week number you require your order to be despatched in Cell A3"

I did this in word over 10 yrs ago and have long forgotten how to, so assume
it can be done Excel - but I am not sure "what" to search for in the help
section?

any suggestions welcome

thanks Sue