Need a shaded row in Excel that doesn't move as data changes
 

How do I get a shaded row on an Excel worksheet that does not move? I know
how to shade a row, but each time the data filters, the shading moves with
the data. I need specific rows to maintain their shading as the data changes.

Need a shaded row in Excel that doesn't move as data changes
 

You could use conditional formatting.
If row 10 is to be shaded select the row 10 cells, then in the Formula
Is box of the conditional formatting dialog use...

=ROW()=10

Ken Johnson