Practical issue: Speed navigation and improve reliability or references and formulae
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
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.