|
I think excel is the same as the open office spread sheet.
If you want to reference a cell on a different sheet then you can type in the = sign in the cell where you want the information; then click on the sheet you want and then click on the cell you want. Press return. You should go back to the cell where you've just entered this "formula"
If you want that to be a fixed value then you need to add in a $ sign for each part of the formula to fix it. So $SHEET $COLUMN $ ROW Then it won't move. If you want for example the whole column on another sheet just $ up to the column and leave the row. Copying from your new cell will reference to the subsequent values above or below the original cells...
|