Switches the AutoInput function on and off, which automatically completes entries, based on other entries in the same column. The column is scanned up to a maximum of 2000 cells or 200 different strings.

Deactivating Automatic Changes

To access this command...

Choose Tools - AutoInput.

The completion text is highlighted.

When typing formulas using characters that match previous entries, a Help tip will appear listing the last ten functions used from Function Wizard, from all defined range names, from all database range names, and from the content of all label ranges.

AutoInput is case-sensitive. If, for example, you have written "Total" in a cell, you cannot enter "total" in another cell of the same column without first deactivating AutoInput.

Please support us!