Page 40 - Excle-En-V3
P. 40

Figure38 : Naming cell or range of cells using Defined Names

            The new name can be used in formulas directly by typing the name of the range
       in the formula, or from the (Use in Formula) command, or by selecting the range,
       clicking the F3 key, and typing the name from the Paste Name box.

                                               Figure 39: Using name in formula

32 Central Unit for Information Technology Training - Supreme Council of Universities © Intellectual Property Rights 2024
   35   36   37   38   39   40   41   42   43   44   45