In Excel 2007-2010 we have an option on the Ribbon on the Insert tab named Table.
This option also exists in Excel 2003 but with the name List.

How do I convert my range to a Table:
If you select a cell in your normal range and press the Table button it will show you this dialog.



After you press the OK button you see a nice looking Table and
If you select a cell in your Table you'll see that there is a new tab named Design on the Ribbon
You'll find a lot of nice options on this tab so you can change the style or do something else.

See this page from MVP Jan Karel Pieterse if Tables are new for you.
http://www.jkp-ads.com/Articles/Excel2007Tables.asp

But as always I want more options so I created a small add-in
that adds a tab next to the Design tab named RDB Tools with a few options.



1) Turn AutoFilter On or Off
2) Clear Filter of the ActiveCell's column
3) Special Filter options : Filter on selected Cell value, Color, Font color or Icon
4) Special Sort Options : Put selected Cell Color, Font Color or Icon on top and Custom Sort
5) Copy Visible data to a new worksheet
6) Copy visible data to a new workbook
7) Delete visible data
8) Print Table
9) Split data of every unique value in a column to a new worksheet of the same workbook
10) Split data of every unique value in a column to a new worksheet in a new workbook
11) Split data of every unique value in a column to a new workbook in a new folder
      This option creates a worksheet with hyperlinks to the workbooks so you can open them easy.

New in version 1.1:

12: Add a  button that open a Userform with a lot of Date filter options
Month/Year
Date to Date
Days
ISO Weeknumbers
Weekday
Nth Weekday
Quarter



13: Add error checking for the 8192 areas limit in Excel in the copy and delete options and add
a option to insert a Sort column named "RDB Sort Column" with numbers 1, 2, 3, .............

When you hit the 8192 areas limit you can do this:

Insert the Sort column named "RDB Sort Column"
Sort the column that you want to filter (less areas if you do this)
Filter this column the way you want
Use a Copy or Delete option in the add-in
Sort the "RDB Sort Column" to get the correct order of the records
Delete the "RDB Sort Column" column

14: Add a button to delete the the Table column of the activecell
Easy if you want to delete the  "RDB Sort Column" for example.


Download

You can download it here together with a small test workbook
If you have suggestions or find bugs please let me know.

Download TableTools.zip
Version 1.12, 19-Jan-2009



More Information about Tables

Overview of Excel tables
http://office.microsoft.com/en-us/excel/HA100485461033.aspx

VBA code examples for a List or Table in Excel 2003-2010
http://www.rondebruin.nl/tablecode.htm

Working with Lists and Tables: VBA Samples (Part 1 of 2)
http://msdn.microsoft.com/en-us/library/dd637097(office.11).aspx

Working with Lists and Tables: VBA Samples (Part 2 of 2)
http://msdn.microsoft.com/en-us/library/dd795215(office.11).aspx

Jan Karel Pieterse (MVP) :
http://www.jkp-ads.com/Articles/Excel2007Tables.asp
http://www.jkp-ads.com/Articles/Excel2007TablesVBA.asp

Frank Rice (MSDN)
Bringing Improvements to Tables in Excel 2007 (Part 1 of 6)
Bringing Improvements to Tables in Excel 2007 (Part 2 of 6)
Bringing Improvements to Tables in Excel 2007 (Part 3 of 6)
Bringing Improvements to Tables in Excel 2007 (Part 4 of 6)
Bringing Improvements to Tables in Excel 2007 (Part 5 of 6)
Bringing Improvements to Tables in Excel 2007 (Part 6 of 6)