Did you mean "it does NOT show all rows"?

If yes, then I'm guessing that you have more than one field/column filtered.

In xl2003 menus, I'd use:
Data|Filter|show all

On the xl2007 ribbon, I think it's:
Data tab|Sort & Filter group|Clear



GV wrote:

When I use Auto Filter and select the criteria I want to filter by and then
go back to select all criteria certain rows are hidden, it does show all
rows. Anyone know why?

--

Dave Peterson