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?
Example:
Say you have fruits in the list in column A:
Apples
Kiwis
Watermelon
But it goes down 100 Rows.
Is it possible to Change Apples...