copy cells and leave the formaula alone?

wking1976 · Mar 18th, 2002, 01:31 PM

I need to copy a bunch of cells that each have a formula and I do not want the formula to change at all. Anyone know how to do this?
TIA

Al Chara · Mar 18th, 2002, 01:55 PM

When referencing cells use a $ to lock its location, for example cell A3 should be entered as $A$3.

Also, if you just want to copy the values, do the following:
Copy the necessary cells, then paste special - just values.

Hope this helps.
Kind regards, Al.

[ This Message was edited by: Al Chara on 2002-03-18 13:00 ]

invisigirl · Mar 19th, 2002, 05:51 PM

I would also add that instead of changing your formulas before the copy/paste, you can go ahead & do the copy/paste and then do a replace for the column assignment. For example, if you have a whole row of formulas that say (just a simple case): =A1/B1, and you're copying it into column F, say, you could just go ahead & do that, and then when the formula adjusts to say =E1/F1, just do a replacement of A for E & B for F.

Is that confusing? Just trying to save you a little time.

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

Mar 18th, 2002, 01:31 PM	#1
wking1976 New Member Join Date: Feb 2002 Posts: 29	I need to copy a bunch of cells that each have a formula and I do not want the formula to change at all. Anyone know how to do this? TIA

Mar 18th, 2002, 01:55 PM	#2
Al Chara MrExcel MVP Join Date: Feb 2002 Location: Monterrey, Mexico Posts: 1,433	When referencing cells use a $ to lock its location, for example cell A3 should be entered as $A$3. Also, if you just want to copy the values, do the following: Copy the necessary cells, then paste special - just values. Hope this helps. Kind regards, Al. [ This Message was edited by: Al Chara on 2002-03-18 13:00 ]

Mar 19th, 2002, 05:51 PM	#3
invisigirl Board Regular Join Date: Mar 2002 Location: Oregon Posts: 130	I would also add that instead of changing your formulas before the copy/paste, you can go ahead & do the copy/paste and then do a replace for the column assignment. For example, if you have a whole row of formulas that say (just a simple case): =A1/B1, and you're copying it into column F, say, you could just go ahead & do that, and then when the formula adjusts to say =E1/F1, just do a replacement of A for E & B for F. Is that confusing? Just trying to save you a little time.