Does anyone know how to auto-fill in Microsoft EXCEL?

[kendogg]

What I mean by auto-fill ( i don't know the right term for it) , is lets say you have to type in the word "Check" alot

After inputing it a few times, you just type in 'C' and it auto-fills so you dont have to keep on typing it over.

HOW DO YOU ENABLE THIS? Its really wierd because one one column it works but for some columns it doesnt

can anyone help me out?

 

[her209]

Copy + Paste

or put some kind of mark and then do a Find + Replace

 

[tarheelmm]

I think you are looking for auto complete:

Do the oppisite of below:
Q: How can I turn off Auto Complete?

A: AutoComplete is the handy feature that helps you quickly enter information that already exists in a column. As you begin typing, Excel displays a suggested entry; you can just press ENTER to accept it. However, if this feature annoys you, turn it off by choosing Tools, Options, the Edit tab, and un-checking the box next to Enable Auto Complete For Cell Values.