Sheets

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 working with and setting the appearance of the sheets inside the Spread component:

• Working with the Active Sheet
• Working with Multiple Sheets
• Customizing the Sheet Name Tabs
• Navigating Sheet Tabs
• Adding a Sheet
• Adding ChartSheet
• Removing a Sheet
• Showing or Hiding a Sheet
• Moving a Sheet
• Selecting Multiple Sheets
• Copying and Inserting a Sheet
• Protecting a Worksheet
• Form Controls
• Adding a Title and Subtitle to a Sheet
• Placing Child Controls on a Sheet
• Displaying a Footer for Columns or Groups
• Adding a Tag to a Sheet
• Working with 1-Based Indexing
• Customizing Clipboard Operation Options

For more details on the objects involved, refer to the SheetView class and SheetViewCollection class.

See Also

Rows and Columns

Headers

Cells

Customizing the Sheet Appearance

Spread Designer Guide