1. Welcome to TechPowerUp Forums, Guest! Please check out our forum guidelines for info related to our community.

Microsoft Excel 2003 question

Discussion in 'General Software' started by Yin, Mar 9, 2009.

  1. Yin

    Yin

    Joined:
    Feb 19, 2006
    Messages:
    542 (0.17/day)
    Thanks Received:
    32
    Hey everyone,

    Just wondering if anyone knows how to make cells equal their values instead of it being a function.

    say for example
    A​
    1
    x​
    2
    =a1+1​
    3
    =a2+1​
    4
    =a3+1​
    5
    =a4+1​

    so i can move them around without the values changing

    Thanks all!
     
  2. Polarman

    Polarman New Member

    Joined:
    Jun 24, 2008
    Messages:
    1,627 (0.68/day)
    Thanks Received:
    292
    Location:
    Rimouski
    Not sure what you mean. :confused:
     
  3. Yin

    Yin

    Joined:
    Feb 19, 2006
    Messages:
    542 (0.17/day)
    Thanks Received:
    32
    okay i'll try to re word it
    letters = columns
    numbers = rows

    so lets say
    A1 = "10"
    A2 = "=A1+1"
    A3 = "=A2+1"
    A4 = "=A3+1"
    A5 = "=A4+1"

    so what we see is
    A1 = 10
    A2 = 11
    A3 = 12
    A4 = 13
    A5 = 14

    its kinda confusing =/
     
    Last edited: Mar 9, 2009
  4. phanbuey

    phanbuey

    Joined:
    Nov 13, 2007
    Messages:
    5,215 (2.00/day)
    Thanks Received:
    984
    Location:
    Miami
    hrm... it would have to be a function in any case.
     
  5. Akumos

    Akumos

    Joined:
    Nov 30, 2008
    Messages:
    552 (0.25/day)
    Thanks Received:
    28
    Location:
    Birmingham, England...
    Or could be a simple formula. have a hidden column of formulaes and link??

    Don't think it's possible wihtout a function or formula though... interesting to see what other poeple write.
     
  6. newtekie1

    newtekie1 Semi-Retired Folder

    Joined:
    Nov 22, 2005
    Messages:
    20,263 (6.10/day)
    Thanks Received:
    6,299
    The only thing I can think of is having the formula calculate the value, then copy the value, and do a paste special to paste the value into the cell.
     
    Yin says thanks.
    Crunching for Team TPU 50 Million points folded for TPU
  7. Yin

    Yin

    Joined:
    Feb 19, 2006
    Messages:
    542 (0.17/day)
    Thanks Received:
    32
    I think it would be easier if you guys look at the file.

    Basically you will noticed the dates are all in a formula and I wanna just get my own time table so i know when i'm working
     

    Attached Files:

  8. theeldest

    theeldest

    Joined:
    Feb 7, 2006
    Messages:
    652 (0.20/day)
    Thanks Received:
    140
    Location:
    Austin, TX

    The way I understand it, you want the values from those cells in different Cells?

    So you want:
    B1= 10
    B2= 11
    B3= 12
    B4= 13
    B5= 14

    Is this right?

    If so, you want to enter:
    B1= "=A1"
    B2= "=A2"
    B3= "=A3"
    B4= "=A4"
    B5= "=A5"

    The easiest way to do this is click in the cell you want the value to appear in. Hit the equals sign, then click the source cell you want it to mirror. Then hit enter.
     
  9. Yin

    Yin

    Joined:
    Feb 19, 2006
    Messages:
    542 (0.17/day)
    Thanks Received:
    32
    well I don't even know how the excel file really works to be honest, but basically I want to get rid of the other people and move all mine into a nice simple line.
     
  10. Steevo

    Steevo

    Joined:
    Nov 4, 2005
    Messages:
    8,576 (2.57/day)
    Thanks Received:
    1,329
    "$"


    Will maintain a constant across multiple cells.


    So if I wanted A1 to be a constant and multiply a range of dependants without changing it you will have to use a "$"sign. When all else fails, use help.
     
    10 Million points folded for TPU

Currently Active Users Viewing This Thread: 1 (0 members and 1 guest)

Share This Page