copying formulas

jbrown · May 18th, 2002, 05:26 AM

I am trying to copy a formula exact from one cell to another, but when I do, excel changes the formulas cell references or ranges. How can I copy a formula exact without excel changing it?

Please Help!

Thanks!

Audiojoe · May 18th, 2002, 05:32 AM

You have to use the $ sign around the cell reference, so A1 would be like this - $A$1

Audiojoe

topswim · May 18th, 2002, 05:44 AM

Also, A shortcut to the $ sign is to click into the cell and press the F4 key.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 18th, 2002, 05:26 AM	#1
jbrown New Member Join Date: May 2002 Posts: 7	I am trying to copy a formula exact from one cell to another, but when I do, excel changes the formulas cell references or ranges. How can I copy a formula exact without excel changing it? Please Help! Thanks!

May 18th, 2002, 05:32 AM	#2
Audiojoe Board Regular Join Date: Feb 2002 Location: Where the wild roses grow Posts: 285	You have to use the $ sign around the cell reference, so A1 would be like this - $A$1 Audiojoe

May 18th, 2002, 05:44 AM	#3
topswim Board Regular Join Date: May 2002 Posts: 86	Also, A shortcut to the $ sign is to click into the cell and press the F4 key.