Archive for November 23rd, 2012

Techie Tip of the Week: Create Pop-Up Text in Excel

Friday, November 23rd, 2012
In Excel, you can have a pop-up appear when someone selects a particular cell. This pop-up can provide information to the person entering data — e.g., instructions on how to enter the data.
To create a pop-up in Excel:
  1. Select the cell in which you want the pop-up text to display.
  2. Click the Data tab.
  3. In Data Tools, click Data Validation, and then click Data Validation.
  4. In the Input message tab, check Show input message when cell is selected.
  5. In Title, enter a title for the pop-up window.
  6. In Input Message, enter the text you want to appear in the pop-up window.
  7. Click OK.
  8. Now when the cell is selected, the pop-up appears: