You can have multiple sheets within a workbook. Each sheet is a separate spreadsheet and can have its own appearance and settings for user interaction. Each sheet has a unique name and sheet name tab for easy navigation between sheets.
These tasks relate to setting the appearance of the entire sheet inside the Spread component:
- Working with the Active Sheet
- Working with Multiple Sheets
- Adding a Sheet
- Copying and Inserting a Sheet
- Moving a Sheet
- Removing a Sheet
- Showing or Hiding a Sheet
When you work with sheets, you can manipulate the objects using the short cuts in code, (SheetView and SheetViewCollection classes) or you can directly manipulate the model. Most developers who are not changing anything drastically find it easy to manipulate the short cut objects. For more information on models, refer to Understanding the Underlying Models.
Remember that settings applied to a particular row or column or cell can override the settings that are set at sheet level. Refer to Object Parentage.
For tasks that relate to setting the user interaction at the sheet level, refer to Customizing Interaction with a Sheet.
Return to the overall list of tasks in Understanding the Spreadsheet Objects.