Book Settings

Several groups of properties that apply to multiple sheets and the entire control are available from the Books Settings dialog. These include the environment settings, the display settings, etc. and each are provided on an individual tab in this dialog. From the Book menu, select any of the options and the tab for that set of settings is displayed. Or click one of the buttons from the Book toolbar. For example, the Environment tab is shown in this figure.

For more information about the items in this dialog, move the focus to an item and press the F1 key, or see the following topics:

Settings Item	Topic
Make Edit Mode Permanent	Keeping Edit Mode Permanently On
Replace Existing Text	Replacing Text as You Edit
Handle Clipboard Keys	Turning Off the Clipboard Shortcut Keys
Use Arrow Keys to Exit Edit	Using Arrow Keys to Move Between Cells
Retain Selected Block	Hiding Selections When Not in Focus
Protect Locked Cells	Locking the Sheet
Multiple Block Selections	Selecting Multiple Blocks of Cells
Cell Overflow	Allowing Cells to Overflow
Beep Off	Turning Off the Control's Beep
Cell Drag Drop	Allowing Users to Drag and Drop Cells
Hide Border	Hiding Sheet Borders
Process Tab Key	Using the Tab Key to Move Between Cells
Autosize On	Displaying a Specified Number of Columns and Rows
On Focus Set Cell to Cursor	Preventing Active Cell Change on Focus
Calculate Formulas	Automatically Recalculating and Updating Formulas
Custom Formulas	Allowing Users to Enter Formulas
Edit Overflow	Allowing Text to Overflow in Edit Mode
Formula Sync	Automatically Recalculating and Updating Formulas
Clipboard Options	Copying Data Using the Clipboard Moving Data Using the Clipboard
Pivot Year	Creating and Setting up a Date Cell
Note Indicator	Providing Cell Notes
HighlightStyle	Customizing the Appearance
Note Shape	Providing Cell Notes
HighlightHeaders	Customizing the Appearance

For information on other book-level settings, refer to Book Default Settings and Book Display Settings.

Return to Spread Designer Dialogs and Settings.