THE LARGER AND MORE COMPLEX your spreadsheets become, the harder it is to remember where the most important data is in the file. If you find yourself searching for the same data again and again, consider assigning a range name to the cells containing that data. By assigning a descriptive name to a single cell or range of cells, you will be able to find that data more quickly.
Even though range names are meant to be customized to your requirements, you will still need to follow these simple rules.
Range names cannot contain spaces. Use an underscore to take the place of a space. For example, instead of Spring Sales, the range name would be Spring_Sales.
Range names must begin with a letter, not ...