WorkSHEET Specific Named RangeĪ WorkSHEET Specific Named Range refers to a range in a specific worksheet, and it is not global to all worksheets within a workbook. Note that no spaces are allowed in the name. Workbook Named RangeĪ Workbook Named Range references a specific range from anywhere in the workbook (it applies globally).Īs explained above, it is usually created entering the name into the name box to the left end of the formula bar. Note There are two types of named ranges: Workbook Named Range and WorkSHEET Specific Named Range. To name a selected range, click the name box at the left end of the formula bar, type a name, and then press ENTER.
Ranges are easier to identify by name than by A1 notation.