Pasting formulas

[Barbara]

I'd like to paste formulas ONLY. When I select a range and then use
COPY-PASTE SPECIAL-FORMULAS, values in the original range are pasted as well
as the formulas. Is there some way to avoid pasting the values?

Thanks

 

[Dave Peterson]

And you're sure that the pasted formulas don't evaluate to the same value as the
copied formulas?

If you're positive, maybe it's because you have calculation set to manual.

In xl2003 menus, it's a toggle on the:
tools|Options|calculation tab

 

[Sean Timmons]

You can copy formulas only be going to Edit - Go to - Special - Formulas and
select the types you want. Then copy and paste to wherever you want.

Course this would remove any rows between them...

Alternately, you can use the edit go to to pick constants and delete them.

 

[Barbara]

Thank you for your reply.

The problem is that this method DOES remove the rows between the formulas.

What I'm trying to do is copy a the formulas in a whole column so that they
appear in the same rows in the new column. Specifically, I have a balance
sheet for 2007. The column of numbers includes some cells which are formulas
anad some which are number values. I'd like to set up a new column for 2008
to be filled in by the user with the updated figures, and have the formulas
calculate the sums in the appropriate cells.

Using the method you suggested will locate the formulas and I can copy them
to the new column one by one, but I was hoping there was a more efficient way
to copy the column, keeping the formulas but losing the values.

Any other ideas?

Thanks again.

 

[Sean Timmons]

Do a copy paste first, then edit go to special constants and click the delete
key. Everything stays in the proper row, but constants have been deleted.
Will that do it for you?