\<bookmark_value\>entering entries with AutoInput function\</bookmark_value\>\<bookmark_value\>capital letters;AutoInput function\</bookmark_value\>

AutoInput

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.

The completion text is highlighted.

• To accept the completion, press \<item type=\"keycode\"\>Enter\</item\> or a cursor key.

• To append text or to edit the completion, press \<item type=\"keycode\"\>F2\</item\>.

• To view more completions, press +Tab to scroll forward, or +Shift+Tab to scroll backward.

• To see a list of all available AutoInput text items for the current column, press +Down Arrow.

When typing formulas using characters that match previous entries, a Help tip will appear listing the last ten functions used from \<emph\>Function Wizard\</emph\>, 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.