The method by which you can name a single cell was covered in the preceding section. The following discusses tricks you can use to name large groups of cells, whether adjacent or not.

Naming adjacent cells

   If any row of cells contains the names of the variables that you wish to use in the Instant Database system, Excel can be used to automatically name the cells immediately beneath the row. (In this setting, Excel presumes that you intentionally named the top row as a label to identify what the user should insert into the next row.)

   In the below example, cells it would be A1 through E1 contain variable names. You want to name the cells A2 through E2 with the identical names.

1.Highlight the entire section. In this example, cells A1 through E2 should be highlighted.

2.Click Insert from the tool bar.

3.Click Name and then click Create.

 

excel_naming1

 

4.The below window will open. Click that the names appear in the "Top Row'. (Note that Excel doesn't require that a name reference a single cell. A name can reference a large range of cells. What you are telling Excel in this routine is that the top row cell contains the text you want to use for the name, but that the top row should not itself be part of the named range. The cells referenced by the name will be the remaining highlighted cells in the same column. As applied to this example, the top-most cell will remain the 'title' (but otherwise unaffected) and the single cell beneath the title will be named.)

excel_naming2

   Of course, if you had filled in cells down the left side of any section of your worksheet, you would highlight the block containing the names and the column to the immediate right. And you would check the Left Column box.

   You can check out the results of your work simply by clicking in the various cells you just named. If you click in A2, you will see the word "File_Opened" in the name box. (Note that Excel automatically replaced the space between "File" and "Opened" with an underline. This was to insure compliance with Excel's cell-name naming requirements.)

 

Created with Help & Manual 7 and styled with Premium Pack Version 2.70 © by EC Software