Spreadsheet Options
See Also
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 five tabbed pages as follows:

FileThis contains general options affecting the whole spreadsheet.
BooksContains spreadsheet options for multi-paged books.
ColumnControls settings for columns within a spreadsheet.
ConversionsControls and settings for the conversion of columns between types (Variate,Factor, Text) and the adding of data to columns.
GeneralContains general spreadsheet options.

Options that effect 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