![]() If you don't want anything else being written in these boxes, go to the 'Error Alert' tab and make sure the box is ticked next to the words 'Show error alert after invalid data is entered'.The dialogue box will appear in full again. Highlight your list of options, then click on the little button with the red arrow again. Go to Sheet 2 or wherever you wrote your list of options in step 1. On the right-hand side of the 'Source' box, there is a little button showing a red arrow.This will create a box entitled 'Source' below. A dialogue box will appear.Under the 'Settings' tab, select the drop-down option 'List'. Select the cells you want the drop-down list to appear in.Go back to the table you want the drop-down menu to be in. ![]() Go to Sheet 2 (or a blank sheet) and write a list of the options you want to see in your drop-down menu.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |