Forum Discussion

GB1234's avatar
GB1234
Copper Contributor
Jun 17, 2021
Solved

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
Formulas and Functions
  • HansVogelaar's avatar
    HansVogelaar
    Jun 17, 2021

    GB1234 

    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.

HansVogelaar's avatar
HansVogelaar
MVP
Jun 17, 2021

GB1234 

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.

Resources