Alternatively, you can enter the source manually. This will now be used as a source for your drop-down menu and will be shown the respective dialog field with the formula, which could look something like this: =$C$35:$C$42. With your mouse, mark your employee list.Now, click on the button next to the dialog box “ source.”.Remove the check at “ ignore blank” but keep the check for “in-cell dropdown.”.Under “settings,” select “ list” in the “allow” drop-down.Click on the “ validation” button in the menu ribbon under “data” and a context menu will open.Now click on any empty cell in the work schedule.Note that the sequence will be mirrored in the drop-down menu.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |