named ranges

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

More uses for Excel range names

Just how important are range names?

Excel 2007 Named Ranges - can i edit the Scope of a named range?

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

How to use Excel 2007 tables - Part 2

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

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

Practical issue: Speed navigation and improve reliability or references

New Range Name features in Excel 2007. By Simon Hurst

What range names are and why they are useful

ExcelZone Compendium – worksheets and ranges. By Simon Hurst

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

<b>Pivot Tip 20</b> - Change the Range name to A:K if you intend to add more records

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

Excel Tip: 10 Quick Range Name Tricks

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