What do you think of tables?

[Stacko]

I've only recently started using Excel 2007 (and 2010), and haven't yet got to grips with tables. It seems like a lot of the functionality is around formatting/display but structured references look as though they may be a replacement for automatically-named ranges.

Have you found these a useful addition? Can you recommend use cases?

 

[Derek Brown]

The cell range of 'Names' applied to columns in a table will automatically extend when new rows are added - easier than using OFFSET in the named formula/range.
If you search YouTube for something like "MrExcel 2007 tables" you may find some useful podcasts. Here is one:
http://www.youtube.com/watch?v=xY5dTQpnoes

 

[gino59]

Can't live without 'em!

Took me a while to get used to them but for referencing ranges, it's certainly a lot easier and a lot more "fool-proof" (well, at least for me). No need to define name ranges, etc., etc.

Love 'em!

Cheers,
Gino