This can be very useful if you are entering data into a table containing duplicate entries. This does not work when entering or editing formulas.Ĭheck your (Excel Options)(Advanced tab, Editing Options, Enable AutoComplete for cell values). This will reduce the amount of text you have to enter by preventing you typing in repetitive words.ĪutoComplete matches only exact cell entries, not individual words in a cell. This feature examines the contents of the active column in the data directly above and tries to anticipate what you are about to type.ĪutoComplete is the automatic filling in of your text when you start typing and is switched on by default.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |