![]() Select the “List” choice from the “Allow:” drop-down on the “Settings” tab to restrict data entry in the selected cells to a list of cell values shown in the worksheet.In the “Data Validation” dialog box that opens there are three tabs: “Settings,” “Input Message,” and “Error Alert.” Click the “Settings” tab to set the range of allowable values for the selected cell or cells. ![]()
0 Comments
Leave a Reply. |