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

Kashflow logo
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

The full article is available to registered AccountingWEB.co.uk members only. To read the rest of this article you’ll need to login or register. Registration is FREE and allows you to view all content, ask questions, comment and much more.

Share this content

Replies

Please login or register to join the discussion.

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