copy & paste in excel

T

Trish

When I copy & paste a formula in excel the formula copies but does not work.
eg.
=SUM(F16:F18) is copied from =SUM(E16:E18) but the total is the same as the
original E16:18. This is happening regardless of whether I copy within a
worksheet of from one worksheet to another. If I double click to edit the new
formula it works. What is happening?? I don't want to have to edit alll cells
I copy and paste.

Trish
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy addition formula of non-consecutive horizontal cells 2
Multiple logic functions with multiple sums 2
Embed the same Excel multiple times 0
Visio shape text disappears upon copy paste 1
Excel Macro Copy cells and pastes them in another sheet 2
Paste to excel from word - auto format problem 1
Macro for checking data in a cell against another cell andcopying/pasting data 8
Copy/Paste (Clipboard) Issues 1

Top