Excel filter & page set up questions

Hi, just a few questions on Excel 2007.

1. I'm using an Excel sheet for logging items and sometimes I find it handy to use the filter button so I can have information on something specific in a column. However, it'd be great if I could apply to more than one column as when I try to, the filter button is already highlighted and by clicking on it, it deactivates the filter applied to another column so you have to keep reapplying it for an individual column. Any chance you can apply on more than one?

2. I export data from a website application into Excel which has all the information. I find it a struggle to include everything so it means erasing columns not necessary/changing it to landscape/page size A3 but any pointers on best to save space would be much appreciated so it can be compact and filled with information!

 

It would appear Floyd that we don't have an abundance of Excel gurus here at CHF. We'll have to see what we can do about that. In the meantime please check out the links below for more in depth help with Excel.

http://www.excelguru.ca/forums/forum.php

http://www.mrexcel.com/forum/

The image below is taken from Excel 2013, but may be of use to you. I'm sure 2007 must have something similar.
Check out "Custom Sort" from the drop down menu.