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.