PDA

View Full Version : How to remove input instructions



admin
2nd August 2011, 05:02 PM
You can disable instructions in the bet sheet using the following procedure. These steps may vary depending on your version of Microsoft Excel.


Go to the Bets sheet
Select Tools -> Protection -> Unprotect sheet. The password is sport
Highlight the column within the input table (not the entire Excel column) that you wish to remove instructions for
Select Data -> Validation -> Select the 'Input Message' tab
Deselect the box for 'Show input message when cell is selected'
Click on OK to save your changes.

You'll have to do this for each column separately to avoid erasing the validation criteria.