Results 1 to 4 of 4
  1. #1
    Lounger
    Join Date
    Aug 2002
    Location
    Kankakee, Illinois, USA
    Posts
    39
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Keeping a value constant (Excel 2000 SP3)

    I am creating a series of formulas, and need to keep one value constant throughout the whole system. How do I make a particular value remain constant, when all other values need to change through the different rows? For example, I am using date calculations, and need today's date to remain the same through out the whole system. But when I click and drag, every value changes by one according to how many rows I drag down. Please help. Thank you.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Keeping a value constant (Excel 2000 SP3)

    If you always want the current date, use the formula =TODAY(). If you want to enter a fixed date, there are several possibilities:
    - Select a column of cells, enter the date, then confirm with Ctrl+Enter. This will enter the value in all selected cells.
    - Enter the date in the first cell, then drag the fill handle with the right mouse button. When you release the mouse button, a popup menu will be shown. Select Copy Cells.
    - Enter the date in the first cell, copy it, then paste into the cells below.

  3. #3
    4 Star Lounger
    Join Date
    Sep 2004
    Location
    Sacramento, California, USA
    Posts
    432
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Keeping a value constant (Excel 2000 SP3)

    Is i the A25 reference you want to remain constant? If so Use an absolute reference $A$25. By using the "$" in front of the row and column references it will fix the reference and it will not change when you drag fomnulas.

    Carla

  4. #4
    Star Lounger
    Join Date
    Dec 2000
    Location
    Tacoma, Washington, USA
    Posts
    68
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Keeping a value constant (Excel 2000 SP3)

    Use Absolute values.
    In your sample, click in to A2 in the formula and touch F4 on the Keyboard. You can also edit the address by hand so that it reads $A$2.
    That means always in column A always in row 2.
    If you want to also drag the formulas down, use $A2.
    Alway column A and adjust the row number relative to the formulas position.
    <IMG SRC=http://www.wopr.com/w3tuserpics/DougKlippert_sig.jpg>

Posting Permissions

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