Formula copying issue

AndrewC

Hello,

I hope you can help.

I am copying some simple formulas from cell to cell. On some it works fine on others (rows are in existence) it won't paste (tried Ctrl+V and using paste menu)

If I copy the formula itself (as opposed to the cell with the formula in it) and paste the formula it does copy but the cell references are the same reference from the cell I copied it from even though they are not absolute cells (i.e. locked with a $).

None of the cells are locked and the general formatting seems OK.

Thanks

Melissa Yamada

Hello @AndrewC

Try checking the formula if the pasted formula is set to the correct rows. Since you're copying through Ctrl + V it is possible that the formula you copied from row 60 with [Assigned To]60 is the same formula on row 61 instead of having the formula as [Assigned To]61 it might be [Assigned To]60 still.

Also, you can try dragging the formula down by hovering your cursor to the corner of the cell.

Melissa Yamada

Happy to help! 😊

Melissa Yamada

Hello @AndrewC

Try checking the formula if the pasted formula is set to the correct rows. Since you're copying through Ctrl + V it is possible that the formula you copied from row 60 with [Assigned To]60 is the same formula on row 61 instead of having the formula as [Assigned To]61 it might be [Assigned To]60 still.

Also, you can try dragging the formula down by hovering your cursor to the corner of the cell.

AndrewC

Melissa you are a marvel!

The drag option has solved my problem.

Thank you very much!

Melissa Yamada

Happy to help! 😊