relative en absolute referencing

[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

 

[Niek Otten]

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!

 

[Dave Peterson]

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.

 

[lennert]

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

 

[lennert]

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