Formula Problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When I drag and drop a formula it is copying the cells only and not the
result, however when I go into the cell and press enter the result is
correct.
 
Tools|Options|Calculate
If Manual is checked, change it to Automatic.

Jerry
 
Hi
goto 'Tools - Options - Calculate' and enable 'Automatic calculation'
 
You must log in or register to reply here.

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

Formula copying error 3
pasting formulas 2
Formula: =PROPER(text), won't display result. 3
Formula result disappeared 5
What causes = not to work? 22
dragging formulas 2
Dragging a formula across the row in 2007 2
VLOOKUP copy and paste problem 2

Back
Top