i'm on excel trying to use this trick i remember i learned but forgot...
basically all it does is when you type the first few letters of something it auto-fills the rest for example say you type S2 it fills it with S2000....i dont remember how to do this anyone help ?

 

I think usually that only works if you have previously typed that exact sentence in a cell that is somehow ajoined (is that a word) to the cell you are in....... as in are typing in words in column a (rows 1-10).... all the rows have to have something in the m (as in no spaces)....then if you go to the bottom and type the first couple letters it will attempt to auto fill out of the choices above or below, but they need to be connected....

easy way..... go to cell A2 and type S2000, then go to either A1 or A3 and type S and it will autofill.... but if you go to A5 and try it it won't work because there is a gap.

 

well i remember i learned something like that in my BCIS class, maybe i confused it with what you said...

 

I believe what you are looking for is the validation feature. This can also be accomplished through the list manager.

 

hmm... well what i'm trying to do is set a daily schedule for some employee. and i figured i'd save time if i have that kind of shortcut help fill the daily schedule faster...

 

why not just copy and paste....?

 

sounds like it might work...but i was hoping the other way was possible too many employees to put down each day like that..

 

thanks for the help anyway

 

If you get rid of the employees the problem goes away, too.



The feature for which you're looking is called AutoComplete; if you look under Tools, Options, Edit you'll see a checkbox for enabling or disabling it.

In my experience--echoed above--you need a contiguous list above or below the cell in which you're typing. I use this all the time when I'm entering data for www.improvemyodds.com; having to type--or copy and paste--100 team names for a day of NCAA basketball, for example, is onerous. I simply paste the entire list below the cells I'm using, type in the names allowing the AutoComplete to help out, then clear the extraneous list.

Good luck!

 

magician is the man, ttt