Wednesday, November 3, 2010

Adding Pop-Up Documentation to a Cell

> Select the cell for which you want the pop-up to appear.
> Choose Validation from the Data menu.
> Make sure the Input Message tab is displayed. (
Click here to see a related figure.)
> Make sure the Show Input Message When Cell is Selected check box is selected.
> In the Title box, enter a title for the pop-up window. (This title appears in bold at the top of the pop-up window.)
> In the Input Message box, enter the text of the documentation you want to appear in the pop-up window.
> Click OK.

If you are using Excel 2007 then you should follow these steps:
> Select the cell for which you want the pop-up to appear.
> Display the Data tab of the ribbon.
> In the Data Tools group, click the Data Validation tool. Excel displays the Data Validation dialog box.
> Make sure the Input Message tab is displayed.
> Make sure the Show Input Message When Cell is Selected check box is selected.
> In the Title box, enter a title for the pop-up window. (This title appears in bold at the top of the pop-up window.)
> In the Input Message box, enter the text of the documentation you want to appear in the pop-up window.
> Click OK.