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?
Bookmarks