Worksheet Properties

Gets or sets the active cell in the worksheet.

Gets the allow edit range collection in the worksheet.

Represents auto filter for the specified worksheet.

Gets and sets worksheet background image.

Gets the Cells collection.

Gets collection of cells on this worksheet being watched in the 'watch window'.

Gets a Chart collection

Gets a CheckBox collection.

Gets worksheet code name.

Gets the Comment collection.

Gets the ConditionalFormattings in the worksheet.

Gets an object representing the identifier information associated with a worksheet.

Indicates if the specified worksheet is displayed from right to left instead of from left to right. Default is false.

True if zero values are displayed.

Gets error check setting applied on certain ranges.

Represents first visible column index.

Represents first visible row index.

Indicates whether this worksheet has auto filter.

Gets the HorizontalPageBreakCollection collection.

Gets the HyperlinkCollection collection.

Gets the index of sheet in the worksheet collection.

Gets or sets a value indicating whether the gridlines are visible.Default is true.

Indicates whether to show outline.

Indicates whether the specified worksheet is shown in normal view or page break preview.

Indicates if the worksheet is protected.

Gets or sets a value indicating whether the worksheet will display row and column headers. Default is true.

Indicates whether the ruler is visible. This property is only applied for page break preview.

Indicates whether this worksheet is selected when the workbook is opened.

Represents if the worksheet is visible.

Gets all ListObjects in this worksheet.

Gets or sets the name of the worksheet.

Represents a collection of OleObject in a worksheet.

Gets the outline on this worksheet.

Represents the page setup description in this sheet.

Indicates whether the pane has horizontal or vertical splits, and whether those splits are frozen.

Gets a Picture collection.

Gets all pivot tables in this worksheet.

Represents the various types of protection options available for a worksheet. Supports advanced protection options in ExcelXP and above version.

Gets the queryTables in the worksheet.

Gets the collection of Scenario.

Returns all drawing shapes in this worksheet.

Indicates whether to show formulas or their results.

Get the Slicer collection in the worksheet

Gets all SmartTagCollection objects of the worksheet.

Gets the sparkline group collection in the worksheet.

Represents worksheet tab color.

Specifies the internal identifier for the sheet.

Gets a TextBox collection.

Indicates whether the Transition Formula Entry (Lotus compatibility) option is enabled.

Indicates whether the Transition Formula Evaluation (Lotus compatibility) option is enabled.

Represents worksheet type.

Gets and sets the unique id, it is same as {15DB5C3C-A5A1-48AF-8F25-3D86AC232D4F}.

Gets the data validation setting collection in the worksheet.

Gets the VerticalPageBreakCollection collection.

Gets and sets the view type.

Indicates the visible state for this sheet.

Gets the workbook object which contains this sheet.

Represents the scaling factor in percentage. It should be between 10 and 400.