Using Edit Mode
- Setting the Edit Mode
- Keeping Edit Mode Permanently On
- Replacing Text as You Edit
- Allowing Text to Overflow in Edit Mode
Overview
When the user enters data in a cell in the sheet or double clicks a cell, the sheet automatically turns edit mode on. When the user moves from the cell, the sheet automatically turns edit mode off. If edit mode is on, the active cell is the cell being edited.
Notes:
|
You can tell the sheet to turn edit mode on or off using code. If you prefer, you can turn edit mode on all the time. In addition, you can specify what happens to existing text in the cell when the sheet turns edit mode on. You can specify whether data overflows into adjacent empty cells while edit mode is on in a cell.