When filtering a table, the filter returns the correct value(s). However, if
you attempt to copy, delete, or format the filtered values, all values are
copied or deleted, even the hidden ones. In Excel 2003, the filter returned
"Visible Cells Only" by default. This is not happening in 2007. I can work
around by gong to Find & Select on the Home tab -- Go to Special and
selecting Visible cells only. This is very tedious and is not the way it
should work. Please let me know what settings I need to change to get the
filters to work correctly.