1. Select a workbook location. It may be one cell or a range (many cells).
  2. Click in the name box, located on the left side of the formula bar.

    Name  Box

  3. Type a short name and hit ENTER.