Hi I need some help.
Something happened my excel sheet and my drop down lists are no longer working the way they used to.
In the simplest terms I had two columns of data.
Column 1 "names" and column 2 is "years".
The top cell of each column had the title (i.e. name & year). These top cells used to have drop down lists with the little arrow.
If I clicked on the cell named "year" it would give me a drop down list of years. And if I clicked on a year in this list it would change the whole sheet to only display the data associated with the selected year.
Now my lists have disappeared and I cant get them back.
Bookmarks