To Select a Range with the Name box, a user needs to type in the first and last cell address of the range he wants to select, with a colon between them, then hit enter. The first cell is the top left of the range and the last cell is the bottom right. So The cell range from A9 to A99 in Excel can be specified with the help of (A9: A99)