Initial Selection

The initialSelection prop sets which cell or range is selected when the editor first renders. The editor will also scroll to make that selection visible.

Interactive Demo

Usage

Pass an A1-style reference string:

// Single cell
<SpreadsheetEditor model={model} initialSelection="A1" />

// Range
<SpreadsheetEditor model={model} initialSelection="B5:D10" />

// Cell on a sheet with spaces in its name
<SpreadsheetEditor model={model} initialSelection="'Sales Dashboard'!F16" />

Note

initialSelection is only applied on first render. Changing the prop after the editor has mounted has no effect — you need to remount the component to apply a new initial selection.

Use Cases

Opening at a specific data range — if you know your data starts at a particular cell, land the user there instead of A1:

<SpreadsheetEditor model={model} initialSelection="A3" />