One improvement?

Though on reflection, it's not such a big deal. See John Walkenbach's comment at:
Excel 2003 Review

(If you don't have Office 2003 or an Active X browser, you can't see the information.
Here's the explanation: Troubleshoot why you can't see some pages on Office Online.)

There is, also, a Quick Reference card.

Toggle Total Row button

This button automatically totals the last column in the list. You would just click the Toggle Total Row button. Voilà! Excel would add an additional row with the word "Total" and with the sum.

Multiple Lists

When you use the List command, you can have more than one list on a worksheet. You can add or delete a row in one list without adding or deleting a row in a list next to it, an ability new in Excel 2003.

Multiple Sorts

You can also sort those lists separately, because using the List command automatically gives each list its own AutoFilter arrows.

You cannot find the Excel List feature in the new Microsoft Office Excel 2007 Ribbon.

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

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.
  
• Keyboard shortcut In addition to CTRL+L, you can now press CTRL+T to create a table.

The List toolbar no longer exists (of course) and you can't insert SubTotals in a table.

Lists turned out to be another one time feature.

[Edited entry from 4/5/2004]




See all Topics