Dollar signs

[AnnaKarin]

Hi,
I wonder if anyone knows if it is possible to remove dollar signs from a formula from several cells as the same time?
Let's say that I have a very simple formula "=C1-B1". I use the dollar signs on cell B1 because that is a constant, so "=C1-$B$1". I then copy the formula to several cells horizontally. After that I need to remove the dollarsigns from all these cells because I want to "fill" the formula vertically in all columns (B1 should then change to B2, B3, etc.). As it is now I have to remove the dollarsigns one by one using the F4 key, but is there any way of removing them all at once?

 

[doofusboy]

Highlight all the cells containing the formulas with $ in them and then use Find & Replace to replace the $ with nothing.

 

[AnnaKarin]

Oh my god that's so simple Of course! Thank you very much!

 

[Jonmo1]

OR,

Instead of
=C1-$B$1

Just use
=C1-B$1


the RED $ locks the Column Reference. So the B stays a B when copied/filled Accross.
the BLUE $ locks the ROW reference. so the 1 stays a 1 when copied/filled Down

 

[AnnaKarin]

Ah, true. And then it's just a one-step thing. Thank you!