Short of sorting the data rather than filtering it, I believe not.

"XLFanatico" wrote:

Why when copy and pasting formats in filtered row the pasting goes all
the way in the row.
The purpose of filtering is to used the filtered cells and leave the others
without
format.
Is there other way to do it ?
Thanks