How do I lock a row in place so that when I sort the worksheet, t.

P

primenumber

How do I lock a row in place so that when I sort the worksheet, the row stays
at its location, and the other rows sort around it?
 
P

Paul Corrado

I believe you can use Data/Filter. Ideally there is already some column in
the worksheet that will show all of the records but that row (maybe a
helper column would be necessary). Then sort the data and set the filter to
show all records.
 
Top