The Spreadsheet Options menu lets you control various functions including the size and appearance of spreadsheets, and their default behaviours. Options that affect spreadsheets are also found within the Tools | Options menu. In particular, date formats within a spreadsheet are set using the Date Format tab.
- From the menu select Tools | Spreadsheet Options then click the Sheets tab.
The Spreadsheet Options menu lets you control various functions including the size and appearance of spreadsheets, and their default behaviours. Options that affect spreadsheets are also found within the Tools | Options menu. In particular, date formats within a spreadsheet are set using the Date Format tab.
The Spreadsheet Options are displayed on seven tabbed pages.
| General | Contains general spreadsheet options. |
| Books | Contains spreadsheet options for multi-paged books. |
| Sheets | Contains spreadsheet options for multi-paged books. |
| Columns | Controls settings for columns within a spreadsheet. |
| Conversions | Controls settings for the conversion of columns between data types (variate, factor and text) and the adding of data to columns. |
| Save | Contains options affecting saving a spreadsheet. |
| Appearance | Contains options for customizing the appearance of the spreadsheet. |