Pasting formulas problem

Trying to copy formulas but don't want to have to readjust them when i've
finished.
Is there any way to prevent this?

eg:

Row 1: =sheet!A1

pasted to:
Row 3: =sheet!A3

but I want:
Row 3: =sheet!A1

Trying to create a timesheet file, quite complex and want to minimise the
workload!

I have found that if I put a # in front of the formula to copy
(#=sheet!A1) then remove the # after pasting it keeps the formula
references the same.

Hope this helps,

Dennis

Hi

Change the formula a bit
=Sheet!$A$1

Or, when you are coping the formula to singel cell, and don't want to use
absolute references for some reason:
Select the cell with original formula, select the formula in formula bar (at
top of Excel window, below menus), and copy it.
Select the cell you want to copy the formula in, point with mouse into
formula bar, and paste the formula in.


--
When sending mail, use address arvil<at>tarkon.ee
Arvi Laanemets


"HHTV Rich" <HHTV [email protected]> wrote in message
news:[email protected]...
> Trying to copy formulas but don't want to have to readjust them when i've
> finished.
> Is there any way to prevent this?
>
> eg:
>
> Row 1: =sheet!A1
>
> pasted to:
> Row 3: =sheet!A3
>
> but I want:
> Row 3: =sheet!A1
>
> Trying to create a timesheet file, quite complex and want to minimise the
> workload!

Thanks.
I searched a bit harder around here and found a similar solution. Worked
like a dream!


"den4673" wrote:

> I have found that if I put a # in front of the formula to copy
> (#=sheet!A1) then remove the # after pasting it keeps the formula
> references the same.
>
> Hope this helps,
>
> Dennis
>
>