General discussion

  • Creator
    Topic
  • #2296783

    Copying formulas in excel

    Locked

    by rdl ·

    I’m trying to copy a formula from 1 cell to the rest of the cells in the same column, but it’s copying the results, not applying the formula. How can I change this. Thanks

All Comments

  • Author
    Replies
    • #2673027

      Reply To: Copying formulas in excel

      by don christner ·

      In reply to Copying formulas in excel

      Select the cell with the formula. Notice the small black square in the lower-right corner of the cell? Float your mouse over that box (your mouse pointer will change to a +). Hold the left button of your mouse down and drag down the column.

      Don

      • #2673025

        Reply To: Copying formulas in excel

        by rdl ·

        In reply to Reply To: Copying formulas in excel

        I’ve done that several times, however, it’s copying the Value of the cell, not applying the formula.

    • #2673022

      Reply To: Copying formulas in excel

      by don christner ·

      In reply to Copying formulas in excel

      In Tools-Options-Calculation do you have automatic recalculation selected?

      Don

    • #2673642

      Reply To: Copying formulas in excel

      by bkotnik ·

      In reply to Copying formulas in excel

      When you go to paste it to another cell, select past special, select formula. This has worked for me in the past.

      I hope this helps.

    • #2673632

      Reply To: Copying formulas in excel

      by rdl ·

      In reply to Copying formulas in excel

      This question was closed by the author

Viewing 3 reply threads