10/29/2023 0 Comments Drop down list in excelYou can write your own error alert message in the boxes on the right-hand side of the dialogue box if you wish. 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'.In the new 'Source' box, write down the options you wish to appear in your drop-down menu, with each item separated by a comma.This will create a box entitled 'Source' below. Under the 'Settings' tab, select the drop-down option 'List'.Open your Excel spreadsheet and select the cells where you want the drop-down list to appear. Photo by Mika Baumeister on Unsplash Method 1
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |