named range

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

Microsoft fixes Excel name range bug

An 'an obscure but very annoying' bug in Excel 2007 that occasionally caused range names to disappear when workbooks were saved has been corrected by a Microsoft hotfix.

Excel Essentials - Five key rules of spreadsheet design. By Simon Hurst

Introduction

<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.