Excel 07: Table Formatting

on Wednesday, September 30, 2009

A cool new feature in Excel 07 is the automatic formatting options available for tables.

If you go to the Insert tab, choose Table, and select the data you want to convert, the Table tools and formatting options will appear in the ribbon.

By default, Excel will band the rows and columns for easier reading. It will also add pulldown filter menus to each of the column headers, a total row at the bottom, and a pulldown menu in the bottom right to quickly get a minimum, maximum, average or sum of your total row. Each of these options can be easily turned on or off in the Table Styles Options section of the ribbon (see below).


Post a Comment