Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Saving words in excel so I can type them in and they pop up

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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,090
Default Saving words in excel so I can type them in and they pop up

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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 553
Default Saving words in excel so I can type them in and they pop up

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I type so my words are vertical not horizontal? ledheadfan Excel Worksheet Functions 2 June 18th 07 04:53 PM
I type same words and it will not automatically repeat the word K@Betts Excel Discussion (Misc queries) 2 January 23rd 06 06:10 PM
how to change all the words of one type(Gunsuh type)to another metumevlut Excel Discussion (Misc queries) 2 November 11th 05 03:29 PM
new sheet the cell doesn't let me type words & numbers excel general question Excel Discussion (Misc queries) 1 November 11th 05 03:25 PM
type mismatch on saving excel calculation mode via VB app Ken Shaffer Excel Discussion (Misc queries) 3 November 2nd 05 01:51 PM


All times are GMT +1. The time now is 02:31 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"