Microsoft Office Tutorials and References
In Depth Information
The Range Name Game
I’ve always been a fan of using range names in worksheets for all the previous
versions of Excel designed for desktop and laptop computers. With this new
version of Excel designed for touchscreen devices, such as Windows 8 tablets
and smartphones, as well, I’m bordering on becoming a fanatic about their
use. Believe me, you can save yourself oodles of time save and tons of
frustration by locating and a selecting the data tables and lists in your worksheets on
these touch devices via range names. Contrast simply tapping their range
names on Excel’s Name box’s drop-down list to go to and select them to
having first to swipe and swipe to locate and display their cells before
dragging through their cells with your finger or stylus.
If I only had a name . . .
When assigning range names to a cell or cell range, you need to follow a few
✓ Range names must begin with a letter of the alphabet, not a number.
For example, instead of 01Profit, use Profit01.
✓ Range names cannot contain spaces.
Instead of a space, use the underscore (Shift+hyphen) to tie the parts of
the name together. For example, instead of Profit 01, use Profit_01.
✓ Range names cannot correspond to cell coordinates in the worksheet.
For example, you can’t name a cell Q1 because this is a valid cell
coordinate. Instead, use something like Q1_sales.
To name a cell or cell range in a worksheet, follow these steps:
1. Select the cell or cell range that you want to name.
2. Click the cell address for the current cell that appears in the Name
Box on the far left of the Formula bar.
Excel selects the cell address in the Name Box.
3. Type the name for the selected cell or cell range in the Name Box.
When typing the range name, you must follow Excel’s naming
conventions: Refer to the bulleted list of cell-name do’s and don’ts earlier in this
section for details.
4. Press Enter.
To select a named cell or range in a worksheet, click the range name on the
Name Box drop-down list. To open this list, click the drop-down arrow button
that appears to the right of the cell address on the Formula bar.