M
marpat
How do I change a range of cells from absolute to relative ie. $h$100*f200
to h100*$f$200, $h$101*f201 to h101*$f$201 and so on....
to h100*$f$200, $h$101*f201 to h101*$f$201 and so on....
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
W
winamw
marpat said:How do I change a range of cells from absolute to relative ie. $h$100*f200
to h100*$f$200, $h$101*f201 to h101*$f$201 and so on....
D
Duke Carey
if you're removing ALL absolutes, select the range of formulas and use Search
& Replace (Ctrl-H) to search for dollar signs and replace them with nothing
& Replace (Ctrl-H) to search for dollar signs and replace them with nothing
W
winamw
marpat said:How do I change a range of cells from absolute to relative ie. $h$100*f200
to h100*$f$200, $h$101*f201 to h101*$f$201 and so on....
W
winamw
marpat said:How do I change a range of cells from absolute to relative ie. $h$100*f200
to h100*$f$200, $h$101*f201 to h101*$f$201 and so on....
Use Edit Replace. It works in formulas e.g. Find $H$ and replace with H