![]() |
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! |
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! |
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! |
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! |
All times are GMT +1. The time now is 07:43 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com