In Excel how to autofill a cell that references a list?
I have defined a list.
Now I am at the drop down on another sheet. Instead of scrolling to the item in the list... (a very long list), I would like to be able to start typing a few letters, and the lists shortens to just that initial input. Much like a combo box can operate in VB.net.
Any help will be greatly appreciated
Rick D Norris, CPA
Software/Hardware used:
Excel
Now I am at the drop down on another sheet. Instead of scrolling to the item in the list... (a very long list), I would like to be able to start typing a few letters, and the lists shortens to just that initial input. Much like a combo box can operate in VB.net.
Any help will be greatly appreciated
Rick D Norris, CPA
Software/Hardware used:
Excel
ASKED:
February 4, 2011 1:42 PM
UPDATED:
May 10, 2012 11:03 AM
Answer Wiki:
Rick when you look at the top on your excel you can see a column of taps which provide you with options.
select one cel than look at the fare end of the column for an optional of "fill".
click on it than more options will appare than click on series
A small plot of options will appare
In series in choose column and in type choose autofill than OK
Than from there all your Cels will be autofilled.
To see all answers submitted to the Answer Wiki: View Answer History.
Try This Link may help u !