1. Home
  2. Setting Workbook Defaults

Setting Workbook Defaults

The Books tab in the Tools | Spreadsheet Options dialog lets you control the default behaviour of workbooks, such as opening large workbooks as read-only, or warning you if the book you are opening has column names that are duplicated in another open book. You can find a full description of all the options here.

Updated on December 14, 2018

Was this article helpful?