What the /Option commands do

These commands set various worksheet options.

Auto
Sets the recalculation mode to automatic or manual recalculation.
Numeric
Sets the cell entry mode to quick or standard numeric input.
Top
Shows or hides the top line display on the screen.
Cell
Shows or hides the highlighting of the current cell.
Encrypt
Selects whether the writing of worksheet files and list files should be encrypted.
PreScale
Selects whether numeric entries should be automatically scaled by .01 when entered.
Ext
Selects whether external functions are enabled.
Set
Allows the setting of other options, i.e. recalculation order, the number of recalculation iterations, and the table format for the /FileTable command.