Get instant live expert help on How do I fill handle 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

unable to populate calculations for 30 and 15 yr. mortgages using the fill handle
Solved by T. Q. in 15 mins
On the Grade Average worksheet, select G7 and type "Average." In cell G8, use a formula to generate the average of the contents in Cells B8:F8. Use the fill handle to populate your results through G10. The syntax for the Excel Average function is the following: AVERAGE(argument1, [argument2],...). Arguments can be numbers, named ranges, cell references that contain numbers, or arrays. Select Cell A12, and enter "Class Average." Use a formula to generate the average of IP Assignment 1 in cell B12. Use the fill across handle to populate your results of averaging the other assignments to F12
Solved by Z. A. in 22 mins
In cell C11, insert a relative reference to the loan amount in C4. In cell D11, insert an absolute reference to the monthly payment amount in G4. In cell G11, use relative references to add the values in cells C11 and F11. Select the range D11:G11, and then use the fill handle to copy the functions to row 12. In cell C12, insert a relative reference to the ending balance in cell G11. Select the range A11:B12, and then use the fill handle to complete the columns through row 70. (Note the cells to select here - it is just A11:B12 - not the whole range.)
Solved by O. J. in 24 mins
I'm trying to use the fill handle to sequentially copy a formula down a column with part of the formula increasing by a value of 6 for each row. Formula: =('Workbook2.csv''!$E$1) The next cell will be Formula: =('Workbook2.csv''!$E$7) Then 13, 19, 25 etc. I filled in the first two rows in the column with the above and tried using the fill handle but it gives an error stating that a trend could not be determined or it just goes 1,7,1,7,1,7,1,7,etc. Am I missing something or is what i'm trying to do not possible?
Solved by G. H. in 29 mins
posting a formula down 3 columns of 15 sheets in a workbook makes excel crash as its too much formula to handle i want an easier method that doesn't make excel crash
Solved by A. W. in 17 mins