ExcelZone Compendium: Working with named ranges (Excel 2007 update)

Share this content
0

Practical issue: Speed navigation and improve reliability or references and formulae

Solutions

Readable formula

Easier absolutes

Including range names in a formula

Not just references to cells

Defining the scope of a range name

Linking to Excel cells or ranges

Two click selections

Further reading

Excel's subtleties in handling references - for example, with absolute or relative locations depending on whether there is a $ sign before the cell figures - can make it difficult to interpret or link to specific blocks of cells. Learning the ways in which you can manage cells and data as named ranges can make life a lot simpler and easier, explains Simon Hurst.

Practical iss...

Please Login or Register to read the full article

Replies

Please login or register to join the discussion.

There are currently no replies, be the first to post a reply.