Fixed Formulas

So I have a column that uses a simple formula =(CC3/$CE$4) with column CC being fixed. I copy it down about 3000 cells. Now I need filter it but I cant change the order of the of column CC. So is there a way to now make all of the cells fixed without inputting $ in all 300 cells. Ex. =($CC$3/$CE$4), =($CC$4/$CE$4), etc.
I need to do this because if I filtered it nothing will change. Does anyone know how to do this?

Hello and welcome to the forum. Try this:

Highlight the entire column, Find & Select > Replace >

Find what: CC
Replace with: $CC$

Replace All

Thank You 63falcondude, that worked! All values now can be sorted without anything changing

You're welcome. Happy to help.

Thanks for the rep!