Microsoft Office Tutorials and References
In Depth Information
Naming Cells and Ranges
Naming Cells and Ranges
To make working with ranges easier, Excel allows you to name them. The name
BookTitle, for example, is easier to remember than the range reference B6:B21. Named
ranges can be used to navigate large worksheets. Named ranges can also be used in for-
mulas instead of typing or pointing to specific cells. When you name a cell or range, Ex-
cel uses an absolute reference for the name by default, which is almost always what you
want. You can see the absolute reference in the Refers to box in the New Name dialog
box. There are two types of names you can create and use: defined name and table name.
A defined name represents a cell, a range of cells, formula or constant, while a table
name represents an Excel table, which is a collection of data stored in records (rows) and
fields (columns). You can define a name for use in a worksheet or an entire workbook,
also known as scope . To accommodate long names, you can resize the name box in the
formula bar. The worksheet and formula bar work together to avoid overlapping content.
Name a Cell or Range Using the Name Box
Select the cell or range, or nonadjacent selections you want to name.
Click the Name box on the formula bar.
Type a name for the range.
A range name can include up to 255 characters, uppercase or lowercase letters
(not case sensitive), numbers, and punctuation, but no spaces or cell referen-
ces.
By default, names use absolute cell references.
To adjust the width of the Name box, point between the Name box and the For-
mula box until the pointer changes to a horizontal double arrow, and then drag
left or right.
Search JabSto ::




Custom Search