Please turn on javascript in your browser to play chess.
Help Forum

Help Forum

  1. Standard member flexmore
    Quack Quack Quack !
    10 May '06 05:58
    when i use copy and paste of a function, i want some variables to refer to the cell to the left - this is easy/automatic.
    i also want some variables to always refer to a particular cell.
    i used to know how to do this and have forgotten!
  2. Standard member John of Reading
    Scotch addict
    10 May '06 12:58 / 1 edit
    Look for "absolute cell reference" in the Excel help. Refer to the fixed-position cell using dollar signs: $A$1
  3. Standard member flexmore
    Quack Quack Quack !
    10 May '06 13:41 / 1 edit
    thanks john ... the exact answer i wanted