[header] How to add a filter in excel 2007 [title] Open the spreadsheet in which you want to filter data. [title] Prepare your data for an excel 2007 autofilter. [step] Excel can filter the data in all selected cells within a range, as long as there are no completely blank rows or columns within the selected range. 
Once a blank row or column is encountered, filtering stops. If the data in the range you wish to filter is separated by blank rows or columns, remove them before proceeding with the autofilter.