Can't find what you're looking for?

Contact us or post in our forums and we'll help you find an answer.

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);