ENTER.DATA

Macro Sheets Only

Turns on Data Entry mode and allows you to select and to enter data into the unlocked cells in the current selection only (the data entry area). Use ENTER.DATA when you want to enter data only in a specific part of your sheet. You can then use that part of the sheet as a simple data form.

Syntax

ENTER.DATA(logical)

Logical is a logical value that turns Data Entry mode on or off.

Remarks

Tips

Related Function

DISABLE.INPUT Blocks all input to Microsoft Excel

FORMULA Enters values into a cell or range or onto a chart

List of Command-Equivalent Functions