Spreadsheet Preferences (View Tab)

This command displays a tabbed dialog box that allows you to customize how the spreadsheet view or spreadsheet pane of a barchart view presents information.

You customize the barchart and histogram portions of the view separately.

To issue the Spreadsheet Preferences command, do one of the following:

  • Display a spreadsheet view and on the View tab, click Preferences from the Table group.
  • Display a barchart view and on the View tab, click Preferences from the Barchart group.
  • Right-click a spreadsheet view or the spreadsheet pane of a barchart view and click Preferences on the context menu.