named ranges | AccountingWEB

named ranges

In his latest contribution from across the Atlantic David H Ringstrom explores some of the lesser known capabilities of that little rectangle at the top left of ev


An article explaining the Named Ranges feature in Excel 2007 remains the single most popular item ever published on

Just how important are range names?

I've copied some sheets that had named ranges in them and this has copied the named ranges across too.


In the second article in his two-part series on using Excel 2007 Tables, Simon Hurst demonstrates how they can automatically update performance charts.

What range names are and why they are useful


In this edition of the Excel Compendium we are going to look at some of the issues surrounding worksheets and ranges.

ExcelZone's Five Minute Tips aim to develop your skill at using Excel pivot tables.


For more useful spreadsheet tricks from AccountingWEB's US managing editor, look in the Expert Guides section for