Learning Range Names

RANGE NAMES This will help you to use the labels of columns and rows on a worksheet to refer to the cells within those columns and rows. Or you can create descriptive names to represent cells, ranges of cells, formulas, or constant values. Labels can be used in formulas that refer to data on the same worksheet; if you want to represent a range on another worksheet, use only a name that is unique to the worksheet. How can we create range names? There are three ways to create range names: 1. Using the Name Box 2. Using the Formula Define Name Command 3. Using the Formula Create from Selection Command 1. Using the Name Box  Select the data range using the mouse – Click Name Box – Type the Range Name – Enter  Application – Enter some values to the selected range – now test following calculations: SUM, AVERAGE, MAX, and MIN 2. Using Formula Name Manager Functions  Select the data range – Click Formulas tab in the ribbon – Click Define Name – Type Rage Name – Select Scope – Enter Comments if you want - Click OK  Application – Enter some values to the selected range – Test different calculation formulas 3. Using the Formula Create from Selection Command  Click Formulas tab in the ribbon – Enter the Abbreviation/ name in to the first column and data range in to the next columns –  Select the Created Table – Click Create from Selection – Tick Appropriate Box – Click OK  Application – Enter some abbreviations in to the first column and values in to the second column – now test different formulas you want