T
tr2yhb
I have a line with 90 columns. I need to copy it down to the 3000
lines below it. The cells in this line contain the following:
H I J
=IF(G14=H9,F14,0) =IF(G14=I9,F14,0) =IF(G14=J9,F14,0)
etc....
I need to replace the "=H9", or what ever column it is, with "=$H$9".
How do I do this without having to go to each cell, highlight the H9
part and hit the F4 function key?
Thank you for your help.
lines below it. The cells in this line contain the following:
H I J
=IF(G14=H9,F14,0) =IF(G14=I9,F14,0) =IF(G14=J9,F14,0)
etc....
I need to replace the "=H9", or what ever column it is, with "=$H$9".
How do I do this without having to go to each cell, highlight the H9
part and hit the F4 function key?
Thank you for your help.