Results 1 to 3 of 3

Fixed cells in a formula

This is a discussion on Fixed cells in a formula within the Excel Questions forums, part of the Question Forums category; Hi, I have created a formula in Excel, where I would like to keep two cells a fixed/constant in the ...

  1. #1
    Guest

    Default

    Hi, I have created a formula in Excel, where I would like to keep two cells a fixed/constant in the formula, but I want to drag the formula down and use the same cells in the formula, without the formula picking up other cells as i drag down... am I supposed to use a $ sign in there somewhere?
    Thanks

  2. #2
    Rest in Peace
    Join Date
    Feb 2002
    Posts
    1,582

    Default

    Hi

    Yes, you are correct, you need the $.

    Select your formula cell, push F2 and the use the F4 key to rotate through relative and absolute. Trial and errror is the best way.



  3. #3
    Board Regular
    Join Date
    Jul 2010
    Posts
    336

    Default Re: Fixed cells in a formula

    If i have understood the question correctly.

    there is another way of doing it... You can name the cell which you want constant in the formula..

    For Example:

    if you have a formula in D1 which is A1+B1+C1 and when you drag it down to the required number of rows then it will be like A2+B2+C2, A3+B3+C3 and so on... whereas, you want A1 And B1 to be fixed/constant in the formula.

    just name cells A1 & B1 (for example a1=code1 & b1=code2)

    now enter the formula in D1 like this =code1+code2+c1 and then drag it down to the required number of rows...

    you will find that only cell c1 will change and code1 & code2 will not change..

    Regards,

    Humayun

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com