IBM Lotus Symphony


Converting cell addresses

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.

Product Feedback | Additional Documentation | Trademarks