Microsoft Office Online
Sign in to My Office Online (What's this?) | Sign in

 
 
Help and How-to
Search
Search
 
 
 
 
Warning: You are viewing this page with an unsupported Web browser. This Web site works best with Microsoft Internet Explorer 6.0 or later, Firefox 1.5, or Netscape Navigator 8.0 or later. Learn more about supported browsers.

What happened to Excel lists?
 

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.

advertisement