Converting cell addresses
From Apache OpenOffice Wiki
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
In a spreadsheet, a referenced cell address is relative
by default. When you copy a referenced address from one cell to another, it changes automatically. You can convert a relative cell address
to an absolute cell address and vice versa.To convert a cell address:
- Select the cell.
- Add or remove the US dollar sign ($) before the row number, the column name, or both. For example, A1 is a relative cell address, while $A$1 is an absolute cell address. If you want to change only the row number during pasting, use $A1.
