Get instant live expert help on how to use autofill in excel
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
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
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
On the GiftBaskets worksheet, in cell F9, use AutoSum to calculate the total items in basket 1. AutoFill the function down to cell F11.
Solved by O. Y. in 11 mins
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
In cell D5 use the TRIM, LEFT, and FIND text functions to extract the guests first name from cell A5. AutoFill the function down to D22.
Solved by C. U. in 16 mins