Spreadsheet Options

Select menu: Tools | Spreadsheet Options

You can select the Spreadsheet Options item from the Tools menu to set options controlling various spreadsheet functions. To save changes to spreadsheet options you should ensure that Save Settings on Exit option is enabled on the Options – Save menu.

The spreadsheet options are displayed on seven tabbed pages as follows:

General Contains general spreadsheet options.
Books Contains spreadsheet options for multi-paged books.
Sheets This contains general options affecting the whole spreadsheet.
Column Controls settings for columns within a spreadsheet.
Conversions Controls and settings for the conversion of columns between types (Variate, Factor, Text) and the adding of data to columns.
Save This contains options affecting saving a spreadsheet.
Appearance Options and settings affecting the appearance of the spreadsheet.

Options that affect the spreadsheet are also found within the Tools | Options menu. In particular, date formats within a spreadsheet are set using the Date Format tab, and fonts and colours are set with the Fonts and Colours tab.

See Also

Updated on November 30, 2017

Was this article helpful?