Microsoft ExcelCells & RangesUser FAQsShortcut keys ...Shortcut Menus ...Entering Data ...

You are watching: The autocomplete feature automatically completes an entry based on previous entries in a column

AutoCompleteClearing CellsRange Intersection*Selecting ...Inserting ...Deleting ...Removing ...Copying ...Pasting ...Flash fill ...Auto to fill ...Sorting ...ComparingUpdates ...VBA password ...Updated: 01 September 202101 September 2021


This function examines the materials of the energetic column in the data directly above and tries to anticipate what friend are around to type.AutoComplete is the automatic filling in of her text when you begin typing and also is switched on by default.This will mitigate the amount of text you have actually to enter by avoiding you keying in repeated words.AutoComplete matches only exact cell entries, no individual words in a cell. This go not work-related when beginning or modifying formulas.Check your (Excel Options)(Advanced tab, modifying Options, permit AutoComplete because that cell values).It have to be checked by default.

This deserve to be an extremely useful if you are entering data right into a table comprise duplicate entries.Whenever you enter text in a cabinet Excel searches just that column of the current an ar to see if the characters match an existing message string in the column. If it finds a matching text string that will immediately fill in the staying characters.Be mindful that this can additionally lead come mistakes if you are entering data that is similar but slightly different.You simply need to form in the first letters or digits of one entry and also any equivalent entries will be displayed automatically.

If the first couple of letters you kind match another cell in the same column Excel will complete the text for friend automatically.

AutoComplete is the automatic filling in of her text as soon as you start typing and is switched on by defaultEvery time you begin typing in a cell, every the entries in the same tower of the current region are scanned and as each character is typed, any possible matches are automatically highlighted.When you repeat perform entries, Excel intuitively says entries based upon the first couple of characters friend type. You can either expropriate the suggestion or continue overtypingYou deserve to either continue typing in order come overwrite or press enter to accept the suggestion.This only matches precise cell entries. This walk not work when inserting or editing formulas.AutoComplete , return you can switch that off.Remember the AutoCorrect and AutoComplete are very different.AutoCorrect happens automatically and also there is nothing you can do to protect against it, other than removed the entry native the list.AutoComplete yet requires girlfriend to press the Tab an essential to accept the suggestion.

Using AutoComplete

Make sure you have the right to edit straight in cells. Inspect your (Tools > Options)(Edit tab, Edit straight in cell).If you room unable to edit straight in cells climate the entry will auto complete in the formula bar.You can accept the tip by pushing either the (Enter) or (Tab) keys.It is feasible to likewise accept the pointer by pressing any type of of the arrowhead keys or through selecting an additional cell.You have the right to remove the highlighted pointer by pushing the (Delete) key.Autocomplete is only displayed after enough characters have been gone into in stimulate to recognize which worth matches.

To ignore just keep typing. AutoComplete only matches complete cell entries and also not separation, personal, instance words.An alternative to making use of AutoComplete is to usage the pick from list drop-down list.This deserve to be displayed by press (Alt + under Arrow) or using the Cell faster way menu.

Pick from a List

An alternative way to get in values that have been entered prior to without re-typing the value is to use the choose from perform feature.A quicker way to choose an existing entry is to right mouse click and also select "pick native List" top top the shortcut menu. This will display screen a drop-down of all the feasible values ?Pick native list obtainable when girlfriend right computer mouse click to display the Cell shortcut menu. The list contains all entries that have been formerly keyed in.Pick from list - If a column has several indigenous all starting with the very same characters, it may be much easier to choose an entry from a drop-down list of choices.This is easily accessible from the Cell shortcut menu. A shortcut food selection is triggered by pressing the ideal mouse switch as protest to the Left.Select the cell straight below and press the right computer mouse button. Pick "Pick indigenous List".

A quick way to display the choose from list drop-down crate is to press (Alt + down Arrow).This will display a drop-down list of the distinctive entries in that shaft from the data directly above.

The list will be immediately sorted right into alphabetical order.Just pick the value you would favor to enter.

See more: When Does A Puppy Open Its Eyes ? When Do Puppies Open Their Eyes


AutoComplete will certainly only complement on exact cell entries and also not on individual words in ~ a cell.This function is on through default return you deserve to switch if off by an altering your (Tools > Options)(Edit tab, enable AutoComplete for Cell Values).AutoComplete walk not work on number or when editing any type of formulas.If the text that AutoComplete displays is no correct, then just proceed typing.

© 2021 far better Solutions Limited. All legal rights Reserved. © 2021 better Solutions limited TopPrevNext