relative en absolute referencing

  • Thread starter Thread starter lennert
  • Start date Start date
L

lennert

i want to copy a range of relative references to another range. then of
course it automatically changes its reference. BUt now I want de
reference to stay absolute for the whole range without manually typing
$ $. HOw do i do that?
lennie
 
One way:

Select the range and Find and Replace all "=" with "\" (or some other
harmless character)
Copy and Paste
Change back to "=" again in both source and destination range

Use a copy of your workbook to try!
 
Change the formulas to text.
select the range
edit|replace
what: = (equal sign)
with: $$$$$$
replace all

do your copy and paste and do a couple more mass changes to put the equal sign
back.

===
If you only have a few cells, you could copy from the formula bar and paste into
the formula bar.
 
thanxs a lot

strange axcel did not make a faster way for this problem.
like using F4 om keybord to make a single cell absolute
 
thanxs a lot

strange excel did not make a faster way for this problem.
like using F4 om keybord to make a single cell absolute
 
Back
Top