Skip to main content Skip to footer

How to start editing a cell immediately as the page loads using JavaScript

Background:

To immediately be editing a cell when the workbook instance loads, we will be using the setActiveCell and startEdit methods. The code below shows how to make cell A1 showing edit mode as the instance loads.

Steps to Complete:

Use the setActiveCell method, and set startEdit to be true

Getting Started:

Use the setActiveCell method to set the active cell for the sheet to be (0,0) or A1.

Set startEdit to true to start editing the active cell.

activeSheet.setActiveCell(0, 0);
activeSheet.startEdit(true);

Mackenzie Albitz