I was wondering,
Is it possible within a Data Validation List, if you select an option in the top cell, for it to change the entire column to that option?
Say you have fruits in the list in column A:
But it goes down 100 Rows.
Is it possible to Change Apples...