Copying only the columns you want to a filtered result set isn’t the same as a filter, but it does allow you to work with only the data you want.

Excel filters help you find exactly what you want, no matter how big your spreadsheet database is. Here's how to set number, text and data filters.

Thats strange, because when I filter then copy rows in Excel 2007, it only copies the selected rows, not the hidden values.<BR><BR>This is Office 2007 SP1, BTW.