Cell Referencing

Blessing

Hello,

I have a formula that I want to drag down a column but I run into issues where after I drag down the formula, I will have to update the reference column. It's time consuming if I have 50 columns.

Purnima Gore

Are you using $ to indicate a fixed reference point?

so as you add lines and used a fixed cell reference it will point to the fixed cell.

ATB

Purnima

Blessing

When I drag the formula on down on column with $246.06. I have to go update each cell to update the

each cell to reference the 1 at the end of the formula......... =[Microsoft Office 365]2 * [$246.06]1

Paul Newcome

You can "lock in" a column and/or row reference as @Cierr suggested by using a $ before the column name and/or row number (whichever you want to lock).

=[Microsoft Office 365]2 * [$246.06]$1

Blessing

It worked. Thanks Cierr and Paul.

Paul Newcome

Happy to help. 👍️