Sheet Options

Sheet level options are options that are specific to the worksheet for which they are set. Sheet options are applicable only in Excel. You do not set sheet options in Word or PowerPoint.

Three options are available for saving sheet level options:

Save as Default Options and Apply to All Worksheets are accessed in Excel by clicking the arrow in the OK button in the Options dialog box (see Figure 57, Save as Default Options, Accessed from the OK Button).

Figure 57. Save as Default Options, Accessed from the OK Button

The Save as Default Options and Apply To All Sheets commands accessed by clicking on the arrow in the OK button.

The following are sheet level options: