Create Names

Allows you to automatically name multiple cell ranges.

To access this command...

From the menu bar:

Choose Sheet - Named Ranges and Expressions - Create.


Select the area containing all the ranges that you want to name. Then choose Sheet - Named Ranges and Expressions - Create. This opens the Create Names dialog, from which you can select the naming options that you want.

рд╕реЗ рдирд╛рдо рдмрдирд╛рдПрдБ

рдирд┐рд░реНрдзрд╛рд░рд┐рдд рдХрд░рддрд╛ рд╣реИ рдХрд┐ рдирд╛рдо рдмрдирд╛рдиреЗ рдХреЗ рд▓рд┐рдП рд╕реНрдкреНрд░реЗрдбрд╢реАрдЯ рдХрд╛ рдХреМрди рд╕рд╛ рд╣рд┐рд╕реНрд╕рд╛ рдХрд╛рдо рдореЗрдВ рд▓рд┐рдпрд╛ рдЬрд╛рдП.

рдКрдкрд░реА рдкрдВрдХреНрддрд┐

Creates the range names from the header row of the selected range. Each column receives a separated name and cell reference.

рдмрд╛рдПрдБ рд╕реНрддрдореНрдн

Creates the range names from the entries in the first column of the selected sheet range. Each row receives a separated name and cell reference.

рдирд┐рдЪрд▓реА рдкрдВрдХреНрддрд┐

Creates the range names from the entries in the last row of the selected sheet range. Each column receives a separated name and cell reference.

рджрд╛рдпрд╛рдБ рд╕реНрддрдореНрдн

Creates the range names from the entries in the last column of the selected sheet range. Each row receives a separated name and cell reference.

Please support us!