Working with Data Tables in Excel 2007

Hi all,

Today I published my first article dedicated to Excel 2007 on my site.

The article is about Excel 2007’s new Table feature and is aimed at the beginner Excel 2007 user (that would be just about everyone except John Walkenbach :-) ).

From the intro:

With the release of Excel 2007, Microsoft has introduced a new concept of working with tables of data. This new functionality is (not surprisingly) called “Tables”.
This article introduces you into the concepts of working with Tables and shows you how they may help you in your everyday Excel use.

Tables in Excel 2007 feature:

Integrated autofilter and sort functionality
Easy selecting
Header row remains visible whilst scrolling
Automatic expansion of table
Automatic reformatting
Automatic adjustment of charts and other objects source range

Read on here…

### Edited to correct the name of the feature ###



Jan Karel Pieterse

Posted in Uncategorized

9 thoughts on “Working with Data Tables in Excel 2007

  1. Using Firefox 2.0 and the Adblock extension, here’s what your site looks like

    I was shocked when I saw it, but then I remembered you had mentioned that the ‘ads’ in the url was causing a problem. Did you decide just to live with it?

  2. I think it has something to do with Frontpage not rendering the navigation control in a manner that FireFox enjoys much. Not sure if the ads thing has anyting to do with it.

    Thanks for letting me know, I might try to change the navigation at the top some day.

  3. At least, you might put up a note encouraging visitors to “whitelist” the site if they are using FF and Adblock. Maybe a link in the sidebar that says “Can’t see Figures?” which would lead to a page explaining how to add the site to the Adblock whitelist.

  4. I don’t know of any ready-made link, you’d have to create it yourself. I was thinking that a visitor would show up at your site, see the captions for the figures, but not see the figures themselves. If there was a link under the ‘home’ and ‘up’ links that said ‘can’t see figures’ then he would click on that and be led to a page you create that explains why.

  5. JK, I had the same problem as Dick. I opened the page and thought, “this would be a lot more effective with some screen shots.” Then I remembered your URL name and whitelisted the domain.

  6. Jan, “data tables” in Excel 2007 is the new name for “tables” of Excel 2003. What you wrote about is called “tables” now, same as “lists” in 2003.

    I bet J-Walk knows that ;-)

  7. John: Gee, that is bad. I’ll look into this. Have you got a reference or a description how to whitelist my site?

    foobar: I know, I’ve just updated the page to reflect that. Thanks.

  8. I call them Named Tables to distinguish them from all the other kinds of tables (Pivot, Data …) and because thats what they are!

Posting code? Use <pre> tags for VBA and <code> tags for inline.

Leave a Reply

Your email address will not be published.