If you frequently work with entire columns or rows of data, you can provide a range name to the cell range, allowing you to quickly identify a group of cells. Instead of manually selecting a large range of cells everytime you want to use them, using a range name allows you to select the range automatically by referring to its name. Additionally, you can use the range name anyplace where you would normally use a cell range reference, such as a formula. Using named ranges also allows you to quickly apply formatting to an entire range of cells.
To Name a Range:
- Select the range of cell you want to name.
- Type the Name for the Range in the Name Box to the left of the formula bar (Note: Range Names cannot contain spaces).
- To adjust the width of the Name box, move your mouse pointer between the Name box and Formula box under the pointer changes into a double arrow. Drag to the left or right.
- Press the Enter key to confirm the entry.
Or
- Select the range of cell you want to name.
- Click the Formulas tab on the Ribbon.
- Click the Define Name button on the Defined Names group on the Ribbon.
- Type in a name for your range
- Type in a description for your range, if desired.
- Click OK.
Similar Posts:
- None Found
Comments on this entry are closed.