![]() Now to specify the range of values you have listed in cell present in excel sheet, follow the same process upto step 3. Now you can see your selected cell becomes a dropdown menu with the values you specified.Ħ. After finishing the above said process click OK button.ĥ. Make sure the IN-CELL DROPDOWN checkbox is being CHECKED. Even SPACE can be used instead of commasĤ. In the SOURCE field fill in the values to be displayed in drop down menu.Separate the values to be listed in drop down menu by COMMAS. Select SETTINGS tab from the dialog box appeared.In the ALLOW field select LIST. ![]() once the cell is selected goto DATA menu select VALIDATION.Data validation dialog box will be displayed.ģ. Select the cell for which the dropdown menu is to be applied.Ģ.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |