Click the Name box list arrow on the formula bar. Click the name of the cell or range. The range name appears in the Name box. All cells included in the range are highlighted on the worksheet.