Attempting to copy a formula by scrolling

S

skluck

I attempt to copy a formula by scrolling down. The formula appears to copy
correctly--increasing by one for each row. However, the value that appears
in the cell remains the same--somehow ignoring the formula that shows up when
you place the cursor in the cell. How do you get the actual formula to copy
correctly? Has anyone else had this problem???

Thanks very much,

Steve
 
T

T. Valko

Make sure calculation is set to automatic:

Tools>Options>Calculation tab>Automatic>OK
 

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
Copy formula 6
Cumulative formula for word table 0
Copying formulas by scrolling 1
Copy & Paste 3
View jumps back to cursor position when scrolling in Word 2007 1
Macro to copy table of contents to a new doc 0
(Advanced Excel) Figuring out a formula of continuous progressiontrying to create 19 Formulas into O 5

Top