Another Autocomplete question!

  • Thread starter Thread starter itsbeal
  • Start date Start date
I

itsbeal

I have created an excel spreadsheet template to keep track of my checkbook
register. At the end of the year I start a new register. How do I make excel
autocomplete the most common text entries that I use frequently in a column
from the previous years?
 
Autocomplete only works with items in cells above the target cell (in
the "active region"). You can't specify how autocomplete operates (other
than off/on).

You could assign (Tools/Autocorrect) an autocorrect entry to your most
common entries. For instance "gr" ==> "groceries", "au" ==>
"automobile", etc.

Note that the autocorrect will be available in all Office apps after you
next close XL.
 
Back
Top