Excel's auto-complete on steroids...

omairhe

Well-known Member
Joined
Mar 26, 2009
Messages
1,887
Office Version
  1. 2019
Platform
  1. Windows
Hey excel gurus,

I recently acquired knowledge about using the built-in autocomplete feature in excel. It is very handy dandy tool. I have currently a list of less than 200 company names with me which I would like to auto-complete to save the time. I will type the company's names starting from row 301. Keeping 100 spare rows in between just in case the list will get any bigger. The formula which goes in row 2 till 300 is

=IF('Data Validation List'!F2=0,"",'Data Validation List'!F2)

The Data Validation List is my sheet name and the company's names start from column F2. This is then copied down all the way up til row 300 of my other sheet.

Now coming to the title of this thread. I learned that hitting backspace five times before typing anything in a cell will boost the auto-complete feature. Is there a code for when alphabet key is hit for the very first time after sheet selection change, then trigger 5 backspaces, prior to entering the pressed alphabet key?

For instance the user hit S and the code triggers 5 backspaces and then types S

Thank you.
 

Some videos you may like

Excel Facts

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand

Watch MrExcel Video

Forum statistics

Threads
1,113,890
Messages
5,544,887
Members
410,643
Latest member
sng
Top