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.