[Solved] Constants in formulas

[Hagar Delest]

I am trying to copy and paste formulas in my spreadsheet to other cells. The software adds rows to the original cell locations in the original formula; I would like it to keep the original cell locations. In Excel if I remember correctly, you simply put a '$' before the cell number to achieve this. Can anyone tell me please what the solution is in NeoOffice? Thank you

[FJCC]

I have never used NewOffice but every other spreadsheet I have used uses the $ before both the column and row.

Code: Select all   Expand viewCollapse view

=$C$12

[robleyd]

You might find [Tutorial] Absolute, relative and mixed references useful reading.

Also, see if there is more information on the NeoOffice resources site

[nolac]

Thank you!