Search all of Office.com
 
Support / Excel / Excel 2007 Help and How-to / Worksheet and Excel table basics / Using Excel tables
 
 

What happened to Excel lists?

Applies to: Microsoft Office Excel 2007

 

Symptoms

You cannot find the Excel List feature on the Ribbon, which is a component of the Microsoft Office Fluent user interface.

Cause

The Excel List feature still exists, but it has been renamed. Excel lists are now called Excel tables.

Resolution

To create an Excel table (previously known as an Excel list), select the range that you want to turn into a table, and then do one of the following:

  • On the Insert tab, in the Tables group, click Table.

Excel Ribbon Image

Keyboard shortcut  In addition to CTRL+L, you can now press CTRL+T to create a table.

  • On the Home tab, in the Styles group, click Format as Table, and then select the format that you want to use.

Excel Ribbon Image

 Tip   This displays the Table Tools, adding a Design tab that provides access to additional table features, such as table options and styles.

For more information on how to create a table, see Create or delete an Excel table.