Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I type a lot of part numbers into excel. Is there a way for me to enter all
the part numbers I use in excel and whenever I type the beginning few numbers or letters of a specific part number possible matches pop up? Does this make any sense? I dont know what this is called. Please help, it would save me tons of time |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
The closest you can come to something like that is to use Data Validation.
In your case, you would put the same Data Validation into each cell in which you want to place a part number. When you select any one of these cells, you will get a down arrow to the right of the cell. Clicking on this down arrow produces a display of all the part numbers that you have. Clicking on one of the part numbers would place that part number into that one cell. Does this sound like something you want? Post back to get help in setting this up. HTH Otto "kselg" wrote in message ... I type a lot of part numbers into excel. Is there a way for me to enter all the part numbers I use in excel and whenever I type the beginning few numbers or letters of a specific part number possible matches pop up? Does this make any sense? I dont know what this is called. Please help, it would save me tons of time |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Kselg
You can also, in a list of column, press ALT+Down Arrow to list all the entries above and can easily select one instead of typing the same again. "kselg" wrote: I type a lot of part numbers into excel. Is there a way for me to enter all the part numbers I use in excel and whenever I type the beginning few numbers or letters of a specific part number possible matches pop up? Does this make any sense? I dont know what this is called. Please help, it would save me tons of time |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I type so my words are vertical not horizontal? | Excel Worksheet Functions | |||
I type same words and it will not automatically repeat the word | Excel Discussion (Misc queries) | |||
how to change all the words of one type(Gunsuh type)to another | Excel Discussion (Misc queries) | |||
new sheet the cell doesn't let me type words & numbers | Excel Discussion (Misc queries) | |||
type mismatch on saving excel calculation mode via VB app | Excel Discussion (Misc queries) |