If you only want to show information from a few columns and filter then look at "Advanced Filters"
http://www.contextures.com/xladvfilter01.html