how to make cell ranges static

[abdulrazzaq1968]

I want to make range static for all cells in a column. For example I want to calculate c1=b1/max(b1:b10) and then c2=b2/max(b1:b10). In this I want to keep max(b1:b10) unchanged for all cells in column c.

[#2 · Accepted solution]

Hi @abdulrazzaq1968 

You can freeze cell range by wrapping them with $. Paste the below formula in C2.

C1=B1/MAX($B$1:$B$10)

Thanks

Tauqeer

[#3]

@tauqeeracma thanks a lot. Your suggested solution solved my problem.