Excel Cell Dropdown

  • Thread starter Thread starter smd111
  • Start date Start date
S

smd111

While we are entering data in to EXCEL, excel is giving us hint some
time if typed data is already before in same column, how ever it's not
work with so much consitancy that every time we will get hint while
typing. also it's not true for numbers we never get such hint.

*I am looking for general solution so we always get hint even if
database is much bigger millions of data, so never need to type again
all names & account number which are already there *
 
Unfortunately Excel's autocomplete is functional only if the values are
contiguous in a column, either above or below the point of entry.

Autocomplete does not function across columns or on non-contiguous areas in a
column.


Gord Dibben Excel MVP
 
*I am looking for some kind of macros or add-ins , so AUTOCOMPLET
,while typing work with much more consistancy. that's saves great tim
while entering huge data entry.

i am sure some might have already this.
 
Back
Top