Discussion on:

Put Excel 2007's new Table feature to work for you!

How do you create colored maps out of datable to show for example repartition of your revenue worldwide. Does Excel 7 allow you to do that? or any other software

Will definitely make some of what I do a lot more efficient - one issue though, mentioned in the article is "Notice that as you scroll down, the heading labels are still visible, without a single keystroke from you" - this did not happen for me, I still had to go to View - Freeze Panes. Is there a setting which needs to be set to make it default to freezing the headers in the table?

The table feature does not work with multiple row headings. I frequently use multiple columns for portions of a piece of data with a group of merged cells above them to group them. For instance, 4 merged cells each for latitude and longitude. The individual column headings for the 4 columns are in the next row: degrees, minutes, seconds, and N/S or E/W. Tables do not work well in this case. It un-merges the top row, adds "ColumnX" headings to the newly blank heading cells, and treats the second heading row as the first row of data.

Hi Susan -

I agree that the Table Tools in Excel 2007 are terrific. Here is a link to a short video that I created on this topic (Five Benefits from Excel 2007 Tables):

http://www.thecompanyrocks.com/5-benefits-from-tables-excel-2007/

Danny Rocks
The Company Rocks
www.thecompanyrocks.com