O'Reilly logo

Learn Excel 2011 for Mac by Guy Hart-Davis

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required