Скачать или смотреть Create Named Range from selection with Headings

A quick way to create names is to base them on column/row headings. In the example shown in below video, the cells from row 2 onward will be named based on row 1 heading.
A. Select the cells with heading that are to be named. The headings can be above, below, left or right of the cells to be named. In below example it is above the range.
B. On the Ribbon, click the Formulas tab, then click Create from Selection.
C. In the Create From Selection window, add a check mark for the location of the Heading, then click OK. In this example, the Headings are at top of the column of the selected cells.
D. Select cells to see its name.
NOTE: If the labels contains spaces, they're replaced with an underscore. Other invalid characters, such as & and # will be removed, or replaced by an underscore character.

For full blog article on NAMED RANGES, go to http://xlguru.in/blog-excelguru/