Export (0) Print
Expand All
Expand Minimize

WorksheetBase.ScrollArea Property

Gets or sets the range where scrolling is allowed, as an A1-style range reference.

Namespace:  Microsoft.Office.Tools.Excel
Assembly:  Microsoft.Office.Tools.Excel.v4.0.Utilities (in Microsoft.Office.Tools.Excel.v4.0.Utilities.dll)

public string ScrollArea { get; set; }

Property Value

Type: System.String
The range where scrolling is allowed, as an A1-style range reference.

Cells outside the scroll area cannot be selected.

Set this property to an empty string ("") to enable cell selection for the entire sheet.

The following code example uses the ScrollArea property to set the scroll area of the current worksheet to the range of cells from A1 to Z100.

This example is for

a document-level customization.

private void SetScrollArea()
{
    this.Range["A1", "Z100"].Value2 = "X";
    this.ScrollArea = "A1:Z100";
}

Show:
© 2015 Microsoft