Get instant live expert help on how to autofill numbers in excel

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

I am using countif to count the number of times certain values (the numbers 1 - 77) appear in a column, but when I use autofill, the criterion does not increase incrementally. That is, I have countif(F:F, 1), countif (F:F, 2), countif(F:F, 3) etc. When I drag, that series repeats (123, 123, 123, etc.) How do I get autofill to increase the criterion stepwise?
Solved by F. F. in 28 mins
Trying to use the autofill option in excel but when I highlight the cell and drag the little green box across nothing happens.
Solved by I. J. in 14 mins
My excel doesn't autofill even when i drag down, it only repeats the values, i have used the flash fill but the best i get is a linear series counting from the value directly above. it can't continue a series of even numbers. i use an excel 2016 (professional plus) but an excel 2007 proved the same, on videos i watch their excel was able to autofill first names from full name, not the case for mine, please assist me!
Solved by M. C. in 16 mins
Need help value of one cell depending what I type in another autofill
Solved by D. D. in 23 mins
i have a 16 digit number in xcel and trying to figure out how to use the autofill. It keeps just duplicating my sequence instead of counting up
Solved by B. D. in 22 mins