Setting Smart View Options

Set options for displaying data, members, formatting, and advanced settings using the Smart View Options.

In the Options dialog, you can set global options in the Advanced tab. You can set sheets options, including display and formatting options, in the Data, Members, and Formatting tabs.

To summarize:

• Global options apply to the entire current spreadsheet, including any new sheets added to the current spreadsheet, and to spreadsheets that are created later. Changes to global options also affect existing sheets and spreadsheets. The options that appear on the Advanced tab of the Options dialog are generally global options.

• Sheet options are specific to the sheet for which they are set. The options that appear on the Data, Members, and Formatting tabs of the Options dialog are generally sheet options.

  You can also save sheet options as the default for any new content that you import from a data source by using the Save Current Options as Default command in the Advanced tab of the Options dialog.