Start filter ur data
Select visible data in col A
Hit F5 and click on Special
Select "Only visible cells"
Hit ok

Now only visible cells in column A is selected
Do ur stuff or maby u can try to Show all first (filter)
then u can se that only ur filtered data is selected

"Pat B" skrev:

When I filter my worksheet based on column A, for example, and adding a value
or color to those filtered values, things seem okay. However, when I remove
the filter all records (even the ones that were filtered out).

is there a setting in excel options that will allow me to shut that off so
when I copy/paste or fill the filtered values, it only affects those values -
not the ones that are hidden (or filitered out).

Thank you in advance for any help you can provide.