CODEWITHSUNDEEP
excel
Fatime
Fatime

Reputation: 197

Repeat some operation in the same column

I'm new to excel. I want to subtract All element of A from I1 and then divide it by J1. So, I use =(A1-l1)/j1 and then paste the same operation for other element but it doesn't work and the operation convert to =(A2-l2)/j2 and =(A3-l3)/j3 ...but I want =(A2-l1)/j1 and =(A3-l1)/j1 what should I do?

Thanks.

enter image description here

Upvotes: 0

Views: 185

Answers (1)

chiliNUT
chiliNUT

Reputation: 19573

Instead of

=(A1-I1)/J1

Use

=(A1-I$1)/J$1

a $ before a row number ensures it will not change, and you can also put $ before a column letter, such as the case with =$A1 or even =$A$1 to freeze both.

In windows pressing F4 in the formula editor will do this for you. It will cycle thru putting a $ before letter and number, and then both, and then neither. if no values in the formula are highlighted, it will affect the value the cursor is on. otherwise, it will affect any and all highlighted range values. its called absolute reference.

Upvotes: 1

Related Questions