Results 1 to 4 of 4

Thread: Copying formula problem

  1. #1

    Copying formula problem



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I can no longer just click a formula and drag it down to copy. Instead the new formula is there, but the amount is the same as the original cell. Any suggestions?

  2. #2
    Conjurer CheshireCat's Avatar
    Join Date
    Dec 2011
    Location
    Victoria, Canada
    Posts
    121
    Articles
    0
    Excel Version
    Microsoft Excel 2013
    Check your options to ensure calculations are set to automatic as opposed to manual.

  3. #3
    Thank you CheshireCat. Somehow my Calculation Options did get set to manual.
    JB9140

  4. #4
    How did they get to manual?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •