Removing table column buttons?

[Blue Max]

Is there a way to remove the sort/filter buttons from specific columns in an
Excel 2007 table?

Our tables have certain columns that are very narrow and that we will never
need to be sorted or filtered. Furthermore, the buttons cover-up the
heading labels in those columns. Is there a way to manually disable the
sort/filter feature for specific columns and remove the buttons?

We also notice that converting a range to a table often changes the column
size, especially of smaller columns. Is there a way to prevent this
behavior?

Thank you for any help with these items.

 

[Gary Keramidas]

a couple things. let's say you have columns A-M in the table. if you just want
to filter on one column, there is no need to select the entire range. just
select the column you want to filter and create the criteria. the other columns
will be filtered, too.

or, you can remove all of the dropdowns using code.

 

[Shane Devenshire]

Hi,

If the columns where you want the filters are not adjacent the answer is no.
If the range is defined as a table the answer is no. If the range is not a
table and the columns are adjacent you can apply filters to the selected
columns only.

To turn off all the filters, don't bother with code, just press Ctrl+Shift+L
this toggles the filters on an off in 2007, not in 2003 lists.

 

[Blue Max]

Thank you, Shane, the CTRL-SHIFT-L was exactly what we needed and it works
great. Now that we have the keyboard shortcut, where do we find the menu
equivalent? Or is it an Excel option?

I also assume we can program this into code and place a button on the
worksheet to toggle the visibility of the filter buttons, correct?

Thank you very much,

Richard

***************