Here we’ll use a List to restrict what values can be entered into a cell. Data Validation is used to define restrictions on what data can or should be entered into a cell. As tech nerds, we’re happy that such an option exists within an Excel spreadsheet.Īdding a drop-down list to a cell or range using Data Validation is a simple matter. For example, if you have ever used such a menu for surveys, polls, and web forms, you know how convenient they are. As you may already know, drop down lists make data entry a breeze. However, if you follow the steps above, all data is still accepted and Excel displays a helpful message whenever the cell is selected.Those wondering how to create a drop down list in Excel will be relieved to know that it is easier than it sounds. There are, obviously, other ways you can use the Data Validation feature of Excel to check and limit the data that is entered in a cell. In the Input Message box, enter the text of the documentation you want to appear in the pop-up window.(This title appears in bold at the top of the pop-up window.) In the Title box, enter a title for the pop-up window.Make sure the Show Input Message When Cell is Selected check box is selected.The Input Message tab of the Data Validation dialog box.

Make sure the Input Message tab is displayed.Excel displays the Data Validation dialog box. In the Data Tools group, click the Data Validation tool.Select the cell for which you want the pop-up to appear.Want a neat trick you can use to make your worksheets more helpful to users? How about adding a pop-up window that displays documentation whenever the cell is selected? To add such a feature, follow these steps:

Mac excel 2013 data validation