pasting fromulas

K

karen

I am changing 2 formulas in over sixty files I wanted to use the clipboard
but when i paste the cells it only paste the values from my original document
not the formulas. The formulas are also not located next to eadh other, one
copy section is A1 to G4 inclusive and the other is A31 to H31.
thanks for you help
 
A

Alan

Go into the Formula Bar and copy the formula there, (after you right click >
Copy you must press Enter), then paste it where you want it. If you copy the
cell you will only get the result as you have discovered. Another way,
change
=A1+B1 to
'=A1+B1, copy the cell, paste and remove the '
Regards,
 
P

Pete

Two ways:

Brute: Go into the cell. Hit function key 2 (F2 above the number 1 on your
keyboard). Select the whole formula by holding down SHIFT and then HOME at
the same time. Then select EDIT>COPY and go the the same row and cell in the
ohter spdsheets and paste it in.

Better: EDIT>COPY>EDIT>PASTE SPECIAL>FORMULAS then go to the spdsheet and
paste it in.

Also, if the old formula in the old spreadsheet is the same in all 60
spreadsheets, and is unique, then a quick next step is this. You can go to
EDIT>REPLACE and type in the old formula and the new one and then just
replace it. That dialogue box will re-appear wiht the same FIND WHAT and
REPLACE WITH boxes when you open each subsequent spdsheet. BUT if the
formula you are replacing is not unique, then you do all this but carefully
then click on "Find" repeatedly until you are in the right cell for the
replacement actoin.

I'm not sure older versions of Excel allow the "Better" method.

Hope this helps!

Regards,
Peter
 
Top