P
Paul Moore
Hello,
I have a spreadsheet to which I want to apply Autofilter. However, I don't
want to be able to sort on all columns, that is, I only want to be to filter
and sort the spreadsheet based on some of the columns, with the other
columns having no downward pointing arrow in their headers.
I've found a way to do this for a single column. If I drag and select the
column and enable Autofiler, then Autofilter is only enabled for that
column. But I haven't found a way to do it for multiple and non-contiguous
columns.
Can anyone help?
Many thanks,
Paul
I have a spreadsheet to which I want to apply Autofilter. However, I don't
want to be able to sort on all columns, that is, I only want to be to filter
and sort the spreadsheet based on some of the columns, with the other
columns having no downward pointing arrow in their headers.
I've found a way to do this for a single column. If I drag and select the
column and enable Autofiler, then Autofilter is only enabled for that
column. But I haven't found a way to do it for multiple and non-contiguous
columns.
Can anyone help?
Many thanks,
Paul