Select all the relevant cells, and in the Data tab, click the main part of the split "Data Validation" button. Then, click ...
How-To Geek on MSN
I stopped worrying about spreadsheet audits when I discovered this hidden Excel wizard
Hard-coded numbers (also known as constants) being mistaken for formulas is a serious audit risk because they can lead to inaccurate results when inputs change. Luckily, the Go To Special wizard can ...
Results that may be inaccessible to you are currently showing.
Hide inaccessible results
Feedback