Quote Originally Posted by DanMnz
(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 ?
Hi,

If you 'filter' then you select Rows to display (or not display).

You cannot filter a portion of a row, nor can you select for filter non-contiguous columns, thus your question seems invalid.

You can Filter - select from other columns and leave columns 1 & 5 set to 'All'

Does this help?
---