copying formulas

[Philgraz]

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel Is there a way to copy formulas without any changes to cell reference?

Is there a way to copy formulas that reference a sheet 1 into an adjecent cell that will reference the same cells on sheet 2?

 

[Bob Greenblatt]

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor:
Intel Is there a way to copy formulas without any changes to cell
reference?

Is there a way to copy formulas that reference a sheet 1 into an
adjecent cell that will reference the same cells on sheet 2?

Yes, make sure the formula uses absolute references: $A$1, not relative
references: A1