In MS Excel 2007/2010 using the Home Tab you can format lists as Tables. Just use the "Format as table" button. This table has filters applied and also expands as you add to it - so handy for expanding pivot tables etc. Colour bands can be applied also
Go to MS Excel 2007/2010 Training Tables Toronto Mississaugaga
for more info
Bert Twomey
MS Office & Excel trainer
Toronto, Mississauga, Ontario
