A range is a rectangular-shape block of cells in an excel worksheet. In order to define a range the cell, or range of cells, or nonadjacent selections that you want to name should be selected. And then you should click the Name box at the left end of the formula bar, write the name you want to use for the range and click enter.
