Use the ribbon command Edit names 
to assign names to cell ranges.
For example, if your worksheet has four columns with the sales figures for spring, summer, fall and winter, name these ranges accordingly. After that, a calculation like the following is possible:
=SUM(Spring)
The ribbon tab Formula | group Named areas contains all commands you need for named cell ranges.
Note: This command will not be available if at least one worksheet in your workbook has enabled a worksheet protection (see also Sheet protection).
For more information on working with named ranges, see the next pages. The following topics are covered:
▪Assigning and editing names to cell ranges
▪Defining names automatically from the selection