Identifying Parts with Named Ranges

When you're setting up formulas in your workbooks, you'll often need to refer to particular cells and ranges. You can always refer to cells and ranges using their addresses, but these can be hard to remember—especially if you change their location by adding cells, rows, or columns to your worksheet.

To make your references easier to enter and recognize, you can give a name to any cell or range. You can then refer to the cell or range by that name. Excel tracks the current position of each name, so even if you add or delete cells (or rows or columns), you can still use the name without worrying about exactly where it is.

You can also use named ranges to navigate your worksheets easily: To go to a named range, ...

Get Learn Excel 2011 for Mac now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.