(newbie so terms may be wrong)

If I have a large database of information and wish to filter columns, is there a way to lock particular columns to they don't change. For instance:

If I have 10 columns, and 500 rows, can I filter based on column 2 but make sure when it alphabeticalizes that rows 1 and 5 don't filter, ever, but allow the other 8 rows to filter accordingly ?

red = lock
1 2 3 4 5 6 7 8 9 10
1 2 3 4 5 6 7 8 9 10
1 2 3 4 5 6 7 8 9 10
1 2 3 4 5 6 7 8 9 10
1 2 3 4 5 6 7 8 9 10