Pasting formulas problem

[Guest]

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!

 

[den4673]

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

 

[Arvi Laanemets]

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.

 

[Guest]

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