 NEND | Probably easiest to search for “data validation Excel” on YouTube. Basically you type a list somewhere. Then in the cell(s) that you wish to have the drop-down list, you select Data Validation. In the pop-up menu it will initially say “Allow any value”. You select list and in the location box for the list you highlight the cells where you typed in the list. |