Worksheets¶

Worksheets are accessed via the Worksheets collection of the workbook. This section covers features that apply to the worksheet as a whole.

• Freeze and split panes - Freeze rows and columns, for example a header row, or split the worksheet into separate panes.
• Header and footer - Set headers and footers for printed worksheets, including page numbers, dates and other automatic text.
• Iterating and deleting - Iterate over rows, columns and worksheets, and delete them.

See also¶

• Copy an entire worksheet
• Page setup for PDF export
• Encrypt and protect your workbook