Do you have Excel 2003? If so, select a data range, go to Data menu List
Create List. You'll see a highlighted region with autofiltering dropdowns
and so forth. This very useful feature was fortified in Office 2007. I
haven't played with it much between 2007 and 2003; I think a 2003 list
becomes a 2007 table smoothly, but the reverse not as smoothly.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Tyro" wrote in message
et...
What is a list?

"KJ" wrote in message
...
2 part question.
I have excel 07 and an associate has 03.

I've created a spreadsheet using tables in 07. When I sent it to my
coworker
using 03 I had to re-create the "list". Is there something I could've
done
differently or do I just need to get over it?

Part two: In 07 they give you design options ei every other row is
highlighted.
In 03 I can't find a similar function for the list.

I went from 2000 to 07 so I missed the whole 2003 experience. I would
appreciate any help!