Get rid of $ signs in formulas

  • Thread starter Thread starter Cmatthes
  • Start date Start date
C

Cmatthes

When I am linking one workbook to another, the default formula always has $'s
before and after the Column id. How do I link without having the $'s added?
 
Cmatthes said:
When I am linking one workbook to another, the default formula
always has $'s before and after the Column id.  How do I link
without having the $'s added?
Click to expand...

If when building your formulas you add external references by
switching to other workbooks and selecting the ranges you want, just
press [F4] 3 times just after selecting the external range to change
the range address to fully relative. Alternatively, if there are no
other $s in these formulas, select the cells containing these formulas
an Edit > Replace $ with nothing.
 
Back
Top