Select all the relevant cells, and in the Data tab, click the main part of the split "Data Validation" button. Then, click ...
Whether you're an experienced Excel pro or you've just switched from another spreadsheet software, many of the default settings make the program frustrating to use. But you don't have to settle for ...
Results that may be inaccessible to you are currently showing.
Hide inaccessible results
Feedback