copying formulas

P

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?
 
B

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?
Click to expand...
Yes, make sure the formula uses absolute references: $A$1, not relative
references: A1
 
Top