IBM Lotus Symphony


Naming cell ranges

You can provide names for cell and range references in formulas. Even after you insert or delete rows or columns, Lotus Symphony still correctly assigns the ranges identified by name. Range names must not contain any spaces.

For example, you can name a range like A1:B2 as "Start", then write a formula such as "=SUM(Start)", instead of "=SUM(A1:B2). Or, you can make a formula for sales tax easier to read if you can write "= Amount * Tax_rate" instead of "= A5 * B12". In this case, you would name cell A5 "Amount" and cell B12 "Tax_rate".

To specify range names

  1. Select the range area, then click Create > Name > Define.
  2. Enter the name for the first range and click Add.
  3. You can also name other cell ranges in this dialog by entering the name in the field, and then selecting the respective cells.
  4. Click OK.

Product Feedback | Additional Documentation | Trademarks