Results 1 to 4 of 4

Thread: Changing cells in a formula

  1. #1

    Changing cells in a formula



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

    Hi, I'm new to excel and I'm having trouble changing the cells in one of my formulas.

    Basically I need to change the formula to represent the next row down for example =(G5/(G5+H5)*C5)*2.74 needs to change to =(G6/(G6+H6)*C6)*2.74.

    At the moment I'm having to double-click each cell in the formula and choose the new cell manually and I have to do this a lot so as you can imagine its very time consuming.

    Any help would be very much appreciated. Thanks

  2. #2
    Magician NoS's Avatar
    Join Date
    Jan 2013
    Location
    British Columbia
    Posts
    718
    Articles
    0
    Excel Version
    Excel 2010 64bit
    double click the little black square at the bottom right of the cell with the original formula

  3. #3
    Cheers, that works great for the next row down. Is there a way to do it for a row that is further down the worksheet?

  4. #4

    Changing cells

    Hi


    As per my understanding, you can double click and change the formula,
    You also press clt+' , you see your formula and change it as per your need
    if you have same formula and need to change it for every cell. only next cell has to be changed in that,
    select cell and drag it

    Hope it will work,

    keep smiling

Posting Permissions

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