Excel 2007 Magic Trick #36: NEW TABLE FEATURE: Dynamic Range

Tags:
2007 Colleges Community Database Dynamic Excel Filter Gel Girvin Highline List Mike Ranges Sort Tables
ExcelIsFun
  • Affiliate Submitter:
    ExcelIsFun
  • International International
  • Comments: 0
  • Views: 252
  • Added: 18-Mar-08

Excel 2007 Table feature allows better sorting, filtering and they have Dynamic Ranges. Maybe the MOST AMAZING new feature in Excel 2007: The ability for Tables to have Dynamic Ranges! When you add new data to the table functions and charts will automatically update (No more using OFFSET function in Named formulas like in earlier versions of Excel!).

Excel 2007 Tables Are So Amazing, you won't believe it!

  1. Categories: Science & Tech
Comments on

Excel 2007 Magic Trick #36: NEW TABLE FEATURE: Dynamic Range

3 Comments | Add Comment
  • Dear shiryu008, ...

    Dear shiryu008,

    Yes, and it works in Excel 2003 also! As long as it is a "List" (Excel 2003) or a "Table" (Excel 2007), the range will automatically update when new records are added.

    --ExcelIsFun

    By ExcelIsFun [Affiliate User] 1220721667 Reply Spam Moderate Up Moderate Down
  • Hmmm!, Dynamic ...

    Hmmm!, Dynamic range! got it!.
    y¡thanks excellsfun

    By shiryu008 [Affiliate User] 1220719206 Reply Spam Moderate Up Moderate Down
  • Dear YouTube Excel ...

    Dear YouTube Excel Team,

    Be sure to watch the video response for an extra cool Excel 2007 Table Dynamic Range Trick!

    --ExcelIsFun

    By ExcelIsFun [Affiliate User] 1211990672 Reply Spam Moderate Up Moderate Down
3 Comments | Add Comment