Support

How to Define and Use Names in Spreadsheets 2013

In the Kingsoft Spreadsheets, you can name a cell range. You can also name a formula or constant. A name is a meaningful shorthand that makes it easier to understand the purpose of a cell range, formula or constant, which may be difficult to comprehend at first glance.

The following is a list of syntax rules that you need to be aware of when creating and editing names.

1. The first character of a name must be a letter or an underscore (_). Remaining characters in the name can be letters, numbers, periods, and underscore characters.

2. Names cannot be the same as the cell reference.

3. Spaces are not allowed as part of a name. Use the underscore character(_) and period(.) as word separators.

4. A name can contain uppercase and lowercase letters. However, Kingsoft Spreadsheets does not distinguish between uppercase and lowercase letters. For example, if you create the name “ABC”, and then create another name “abc” in the same workbook, Kingsoft Spreadsheets will remind you to choose a unique name.

Define Name

Defining the name for selected cells will make it easier to refer to the contents in the cell. To define a cell name, follow the steps below:

Step 1 Select the cells which you want to define.

Step 2 In the Formulas tab, click the Name Manager icon and the Define Name dialogue box will open and show as below:

define names in spreadsheet

Figure 1 The Define Name dialogue box

Step 3 Input the name of the cells in the Names in workbook enter box, and then click Add on the right.

Step 4 Click OK to complete the operation.

Create Names

Cell range can be just a cell or multiple cells. These cells can be adjacent or non-adjacent. If you want to define a cell range name, follow the steps below:

Step 1 In the Formula tab, click the Create icon and the Create Names dialogue box will open and show as below:

define names in spreadsheet

Figure 2 The Create Names dialogue box

Step 2 You can create names in Top row, Left column, Bottom row and Right column.

Step 3 Click OK to complete the operation.

Tips: In this way, you can only name a single row or column separately.

Define Formula Name

The operation steps are as follows:

Step 1 In the Formulas tab, click the Name Manager icon and the Define Name dialogue box will open. See Figure 1.

Step 2 Input the name of formulas in the Names in workbook text box, click Add, and input the corresponding formulas in the Refer to box.

Step 3 Press OK to complete the operation.

If you want to delete the name of the cell, cell range or formula, you can select the corresponding name in the list box and click Delete.

Paste Name

You can paste the name used in the current workbook as formula to the selected cells. Follow the steps below:

Step 1 Define the name for the selected cell (follow the steps in Define Name).

Step 2 Select the cell where you want to paste the name you have defined.

Step 3 Click the Paste icon in the Formulas tab and the Paste Name dialogue box will open and show as below:

define names in spreadsheet

Figure 3 The Paste Name dialogue box

Step 4 Select the name you have defined in the Paste Name list box.

Step 5 Click OK to complete the operation. The result is shown as below:

define names in spreadsheet

Figure 4 The Paste Name result