How to Take Advantage of Excel 2007 – 2010 Tables and Excel 2003 Lists

Excel Table Styles

Excel Table Styles

In this video tutorial, I cover multiple versions of Excel. I demonstrate how to take advantage of the Table Tools that were introduced in Excel 2007 and I also show you how to create Excel 2003 Lists.

Topics Covered on Video Tutorial

  • Convert a range of data to an Excel 2007, Excel 2010 Table.
  • Convert a range of data to an Excel 2003 List.
  • View and change the Total Row in each version of Excel.
  • Append new records to Tables and Lists.
  • Add a new field to Tables and Lists.
  • Write a formula in one cell of an Excel Table and have it automatically copy down for each record.
  • Change the Table Styles in Excel 2007 and 2010.
  • Use Conditional Formatting to add alternate row shading to an Excel 2003 List

Watch Video in High Definition on YouTube

Follow this link to watch this Excel Video Tutorial in High Definition on my YouTube Channel, DannyRocksExcels

Download This Excel Workbook

Click on this link to download the Excel Workbook that I used in this video tutorial.

Get my best-selling DVD-ROM, “The 50 Best Tips for Excel 2007” for only $39.95!

Identify your Excel data as a list

Identify your data as a list in Excel so that you can get automatic subtotals and dynamically expand your list.


Here are the steps to follow in this video lesson:

  1. Select one cell in your data and then click Data, List, Create List. The keyboard shortcut is Ctrl+L.
  2. Verify that Excel has identified the range of cells for your list and click OK.
  3. Notice that Excel has drawn a blue border around your list; added drop-down filter menu arrows; and added a floating List Toolbar.
  4. Scroll down to see that there is an * in the 1st blank row beneath your last record in the list. You can add additional records here and Excel expands your list dynamically.
  5. You can also add a new column / field and your list expands to include it.
  6. The Toggle Total Rows button adds an AutoSum to the last column. You can change the Function that it uses by clicking the drop down arrow next to any cell in the Total row.
  7. You can have multiple “lists” in the same worksheet when you identify your data as a list.

Find the Excel Video Lesson that you want – Index to all Excel Topics

News! My DVD, “The 50 Best Tips for Excel 2007” is now available to purchase. I invite you to visit my online bookstore for more details.

Related Video Lessons