I have the auto complete option checked, however, if there are blank cells
above the cell I want to auto complete, it will not recognize any entries
above. Can excel autocomplete from more than the choices directly above it?