In IBM® Lotus® Symphony™ Spreadsheets, 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 converting cell addresses, select the cell and do either
of the following steps:
- Press Shift+F4.
- 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.