I work with Excel lists a lot. Usually for 'Auto-Filtering' and/or for PivotTables.
There is a very nice tool in Excel, which allows you to work with individual 'records' in a list.
The first thing you need to do, is put the 'Form...' button on a toolbar
(the command has no associated icon).
So customize your toolbar and add:
Image:Forms for Excel
Now select a cell in an entry in your list and then click the 'Form...' command.
A dialogbox similar to the following opens up:
Image:Forms for Excel
Note that calculated 'fields' are read only.
You can create new entries on the fly, move from one to the other (using the scrollbar), and use criteria to find items quickly.
A neat tool for the casual user. No programming required !

Category:  Microsoft Excel  | TechnoratiTechnorati: ,