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 AccountingWEB.co.uk.
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.
- New Range Name features in Excel 2007. By Simon Hurst 451,891 6
- Excel Tip: 10 Quick Range Name Tricks 59,697 3
- Excel 2007 Named Ranges - can i edit the Scope of a named range? 18,509 3
- <b>Pivot Tip 20</b> - Change the Range name to A:K if you intend to add more records 11,410 3
- ExcelZone Compendium – worksheets and ranges. By Simon Hurst 9,850