relative en absolute referencing

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

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 wrote:
>
> 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

--

Dave Peterson

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!

--
Kind regards,

Niek Otten

"lennert" <[email protected]> wrote in message
news:[email protected]...
>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
>

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