Filter entire row of data by criteria of certain (not all) columns

[pattobrien]

Hi All,

I have several columns of data, (ie. Name, Date, Company) that I want to be able to filter through. But since it doesn't make sense to filter by date or name, for example, I don't want there to be a filter icon for those specific columns. If I just select the columns that I want to filter by (ie. only Company), then sorting/filtering only affects that column, not the entire row of data, so everything becomes unaligned... Is there a solution for this or will I simply need to have the filter icons in every single column in my spreadsheet?

Thanks for the help!

Pat

 

[Peter_SSs]

Using vba it is possible to hide (or show) the filter arrows for individual columns.
For example, in the sheet below I have an AutoFilter on columns D:J but I want to hide the filter arrow for columns E, F and I (that is the 2nd, 3rd and 6th columns of the filter range.

Sub TurnOffFilterArrows()
  Dim NoFilter As Variant, Itm As Variant

  NoFilter = Split("2 3 6") '<- Columns within the filtered range you want to hide the arrow
  With ActiveSheet.AutoFilter.Range
    For Each Itm In NoFilter
      .AutoFilter Field:=Itm, VisibleDropDown:=False
    Next Itm
  End With
End Sub

20 06 05.xlsm
	D	E	F	G	H	I	J
1	Hdr 1	Hdr 2	Hdr 3	Hdr 4	Hdr 5	Hdr 6	Hdr 7
2	data	data	data	data	data	data	data
3	data	data	data	data	data	data	data
4	data	data	data	data	data	data	data
Sheet2 (3)

 

[pattobrien]

Using vba it is possible to hide (or show) the filter arrows for individual columns.
For example, in the sheet below I have an AutoFilter on columns D:J but I want to hide the filter arrow for columns E, F and I (that is the 2nd, 3rd and 6th columns of the filter range.

Sub TurnOffFilterArrows()
  Dim NoFilter As Variant, Itm As Variant
 
  NoFilter = Split("2 3 6") '<- Columns within the filtered range you want to hide the arrow
  With ActiveSheet.AutoFilter.Range
    For Each Itm In NoFilter
      .AutoFilter Field:=Itm, VisibleDropDown:=False
    Next Itm
  End With
End Sub

Excel 2010 32 bit

	A	B	C	D	E	F	G	H	I	J	K	L
Hdr 1	Hdr 2	Hdr 3	Hdr 4	Hdr 5	Hdr 6	Hdr 7
data	data	data	data	data	data	data
data	data	data	data	data	data	data
data	data	data	data	data	data	data

<colgroup><col style="******* 25pxpx"><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]2[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]3[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]4[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]

</tbody>

Hide arrows​

Thank you; exactly what I needed!!

Pat

 

[Peter_SSs]

Thank you; exactly what I needed!!

Pat

You are welcome. Glad it's what you wanted.