Autocomplete function

[Drsally]

Help! I use excel to enter patients and type of procedure (consultation
xray, capd, etc). I like it when the autocomplete function works t
automatically type the word just above, but if I leave a cell empty
the next cell won't autocomplete. What can I do to make autocomplet
work even if there are empty cells above after other entries in th
same column? I hope someone can understand my explanation and hel
me

 

[swatsp0p]

You have two options, as I see it. The way Autocomplete (AC) works, if
you have data in an adjoining column, AC will work the entire length of
the blank column. Therefore, you could insert a column next to your AC
column and fill will dummy data (enter 'a' and copy down). You can
then Hide the dummy column if you want.

Option two is to enter a space in your empty cells. They will still
look empty, but will allow the AC to continue to work as you go down
the column.

Does one of these work for you?