Sorting columns in Tables

[Davidns]

When creating a table, Excel turns every column in the table into a sortable column via a drop down arrow next to the column name. Is it possible to turn off this sorting ability for some of the columns in a table?

 

[sandy666]

for whole table: Alt+A+T

 

[Davidns]

That's good to know. But is there a way to do it for a particular column?

 

[Fluff]

It's possible to hide the filter button on individual columns.
Which columns are you interested in?

 

[Davidns]

Just a general question. How can the filter be turned off for a particular column?

 

[Fluff]

If you have multiple columns like

Sub Davidns()
   Dim Ary As Variant
   Dim i As Long
   Ary = Array(1, 3, 5, 7)
   With Sheet1.ListObjects("Table2")
      For i = 0 To UBound(Ary)
         .HeaderRowRange.AutoFilter Ary(i), , , , False
      Next i
   End With
End Sub

 

[Fluff]

Or if it's just the one column, like

Sub Davidns()
  Sheet1.ListObjects("Table2").HeaderRowRange.AutoFilter 5, , , , False
End Sub

 

[Davidns]

Thanks - no direct way in the sheet itself?

 

[Fluff]

Not that I'm aware of.

 

[Davidns]

Ok, thanks. I appreciate your assistance.