Naming a range of cells in Excel can come in very handy, and it´s quite simple. 
At the most basic level, naming a range in Excel is no harder than selecting the 
range of cells (this can be a single cell, cell range, or nonadjacent cell 
selection), clicking the Name Box (on the same row as the Formula bar that 
contains the current cell address), typing a unique descriptive name for the 
range, and then pressing Enter. 

To quickly select a cell range or nonadjacent selection after you name it, click 
the drop-down button on the Name Box and select the selection´s name in the drop-
down list. Then, to print the cell selection, choose File, Print, click the 
Selection option button in the Print dialog box, and click OK. 

Not only can you now quickly select that named range, but you can use that name 
in formulas to refer to that range. The great thing about using range names in 
your formulas is that they automatically document their function. This is 
especially helpful to coworkers who have to use your spreadsheets but who had no 
part in their design. When using names in your formulas, you can assign the names 
as you construct new formulas in the worksheet, or you can add them after the 
fact to existing formulas. 

Remember these range name conventions: All range names must begin with a letter 
of the alphabet, contain no spaces (use underscores, please), and not duplicate 
any other name in the workbook (keep those names unique).