Forum Discussion
Copy formula down
If there is a column to the left or right of the cell with the first formula that is non-blank until the last row you need, you can double-click the fill handle (the little black square) in the lower right corner of the cell with the formula.
Otherwise: let's say the first formula is in cell F2.
Press F5 or Ctrl+G to activate the Go To dialog.
Enter F2:F100000 in the Reference box and click OK or press Enter.
Press Ctrl+D to fill down.
Please read this link before continuing
Welcome to your Excel discussion space!
If I may recommend, send the file - workbook / worksheet (without sensitive data) with the problem.
As far as I know, a proposed solution also depends on the formula and its structure.
Thank you for you all understanding and patience
Nikolino
I know I don't know anything (Socrates)