Autofill in columns, interrupted

[mimir]

I have a spreadsheet that has several columns and I am inputting data into it on a consistent basis. One of the columns repeats a word "service." On one occasion I had to interrupt that word by using another phrase. Since that time, the autofill has not worked. There must be a way to reinstate it but I'm at a loss to know what it is. Help!

[Trevor G]

Have you switched the Auto Filter off and then re apply it.

[mimir]

Thanks, Trevor. I haven't made it work yet, but I'm working on it. Appreciate your suggestion.

[ArviLaanemets]

Have you a table defined? And you have some formula in column like ="service"?

When yes, then autofill is switched off whenever something different is inserted into this column - which is logical as Excel doesn't know how to behave after that. And the only advice I can give is to change the formula in this way, that it returns all wanted values, and then copy it to whole column. I.e. don't use entered values and formulas in same column - when you need to enter something manually, add a column and enter manual values there.

Btw. when you manage somehow to make the autofill to work again, then probably your different entry is written ower with formula.