Forum Discussion
Copy formula down
Hello,
I'm reaching out because I don't remember how to instantly copy down my formula (100k rows).
Could you help me please ?
Regards,
GB
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.
3 Replies
- Hello , thank you for your replies ! Both solutions provided by Hans Vogelaar worked.
Thank you a lot 🙂 and have a good day 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)
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.
