changing absolute reference for range of cells

  • Thread starter Thread starter marpat
  • Start date Start date
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....
 
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....
Click to expand...
 
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 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....
Click to expand...
 
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....
Click to expand...

Use Edit Replace. It works in formulas e.g. Find $H$ and replace with H
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

"Relative" Absolute Cell References in Excel 2007 4
Sumproduct cell reference vs embedded "values" 3
Find value within a range and extrapolating....(tiered commission) 1
I need to add an IF condition to a formula 9
multiple entries per cell to save on table size? 3
Conditional Formatting Amendment 2
How do I modify database criteria at formula level? 3
Conditional Sum without Range Parameters 5

Back
Top