Filtering issues?
 

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.

Filtering issues?
 

You need to be super careful that when you are applying color to filtered
cells, that you select ONLY cells with the "blue" row indicators. IF you
also select the header row or anything below the "blue" rows, the color will
be mis-applied.
--
Gary''s Student - gsnu200908


"Pat B" wrote:

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.

Filtering issues?
 

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.