changing absolute reference for range of cells
 

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....

changing absolute reference for range of cells
 

"marpat" wrote:

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....

changing absolute reference for range of cells
 

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

"marpat" wrote:

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....

changing absolute reference for range of cells
 

"marpat" wrote:

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....

changing absolute reference for range of cells
 

"marpat" wrote:

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