Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Help Text in an Excel 2003 or 2007 Worksheet

I designed a worksheet in Excel 2003 to be used by multiple users. When the
users click on a cell, a small box pops up that reminds them of pertinent
information needed to complete that cell correctly. I now have Excel 2007
installed and can't find a way to update the contents of the pop-up "hint"
box, since the original contents are now outdated. Please help! This is
driving me crazy!
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,123
Default Help Text in an Excel 2003 or 2007 Worksheet

I think you are looking for Datavalidation

In 2007 you find it here
On the Data tab in the Data tools group


See also
http://www.rondebruin.nl/0307commands.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"nicklynne" wrote in message ...
I designed a worksheet in Excel 2003 to be used by multiple users. When the
users click on a cell, a small box pops up that reminds them of pertinent
information needed to complete that cell correctly. I now have Excel 2007
installed and can't find a way to update the contents of the pop-up "hint"
box, since the original contents are now outdated. Please help! This is
driving me crazy!

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Help Text in an Excel 2003 or 2007 Worksheet

That's it! You are awesome!! Thank you so much!!

"Ron de Bruin" wrote:

I think you are looking for Datavalidation

In 2007 you find it here
On the Data tab in the Data tools group


See also
http://www.rondebruin.nl/0307commands.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"nicklynne" wrote in message ...
I designed a worksheet in Excel 2003 to be used by multiple users. When the
users click on a cell, a small box pops up that reminds them of pertinent
information needed to complete that cell correctly. I now have Excel 2007
installed and can't find a way to update the contents of the pop-up "hint"
box, since the original contents are now outdated. Please help! This is
driving me crazy!


  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,123
Default Help Text in an Excel 2003 or 2007 Worksheet

If you use it often then add this option to the QAT

Right click on Datavalidation On the Data tab in the Data tools group
and choose Add to QAT bar




--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"nicklynne" wrote in message ...
That's it! You are awesome!! Thank you so much!!

"Ron de Bruin" wrote:

I think you are looking for Datavalidation

In 2007 you find it here
On the Data tab in the Data tools group


See also
http://www.rondebruin.nl/0307commands.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"nicklynne" wrote in message ...
I designed a worksheet in Excel 2003 to be used by multiple users. When the
users click on a cell, a small box pops up that reminds them of pertinent
information needed to complete that cell correctly. I now have Excel 2007
installed and can't find a way to update the contents of the pop-up "hint"
box, since the original contents are now outdated. Please help! This is
driving me crazy!


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 97-2003 Worksheet partially corupted in Excel 2007 but can't Obiwan Excel Discussion (Misc queries) 3 March 13th 08 02:16 PM
email worksheet from Excel 2003 using Outlook 2007 Csabi Excel Discussion (Misc queries) 11 January 13th 08 11:33 PM
Linked text boxes created in Excel 2007 are blank in Excel 2003? Robert Lanning Charts and Charting in Excel 0 December 5th 07 08:26 PM
Wrap Text in 2007 vs 2003 Chris E. Excel Discussion (Misc queries) 1 September 18th 07 03:59 PM
Excel 2003 converted to 2007 copying worksheet error MAC Excel Discussion (Misc queries) 0 September 6th 07 08:16 PM


All times are GMT +1. The time now is 07:43 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"