Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
filters for selective columns?
I have a spreadsheet with around 20 columns. i want the filter button only
on 10 of them. Easy enough if the columns are right next to eachother, i figured out how to do that. My problem is that i only want the filter buttons on columns a, c, e, f, h, l, and p. (these aren't the real columns, just an example.) If it were up to me, i'd either leave all the buttons showing, or move the columns i want filtered right next to eachother. The problem with that is it's not up to me (I'm working on this spreadsheet for three different supervisors and they have dictated the order they want to see the columns in, and seeing the filter button at the top of columns they do not want to filter annoys them.) If I can't have the filter button on selective non-adjacent columns, is there a way i could 'hide' the button on the columns that my bosses don't want to see the filter button on? Thanks in advance, any help would be appreciated. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
filters for selective columns?
It sounds as though you might be interested in "Custom Views".
Check out the Help files, and post back with any questions. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "evilchrissy" wrote in message ... I have a spreadsheet with around 20 columns. i want the filter button only on 10 of them. Easy enough if the columns are right next to eachother, i figured out how to do that. My problem is that i only want the filter buttons on columns a, c, e, f, h, l, and p. (these aren't the real columns, just an example.) If it were up to me, i'd either leave all the buttons showing, or move the columns i want filtered right next to eachother. The problem with that is it's not up to me (I'm working on this spreadsheet for three different supervisors and they have dictated the order they want to see the columns in, and seeing the filter button at the top of columns they do not want to filter annoys them.) If I can't have the filter button on selective non-adjacent columns, is there a way i could 'hide' the button on the columns that my bosses don't want to see the filter button on? Thanks in advance, any help would be appreciated. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
filters for selective columns?
Right-click that sheet's tab and select "View Code." Paste this macro in,
modify it to represent the columns you want the filter button on, press the green play button, delete the macro, then exit the VBA editor window. That's it! Sub HideSomeArrows() 'hide some autofilter arrows Dim c As Range Dim i As Integer 'Assumes headers begin in A1 (1,1)...change as needed in both places below i = Cells(1, 1).End(xlToRight).Column Application.ScreenUpdating = False For Each c In Range(Cells(1, 1), Cells(1, i)) Select Case c.Column 'These are the columns you want to show 'In this example, starting from A1, 2 is column B and 3 is column C 'So this will hide the filter button in column A and columns D to the end Case 2, 3 'Change accordingly c.AutoFilter Field:=c.Column, _ Visibledropdown:=True Case Else c.AutoFilter Field:=c.Column, _ Visibledropdown:=False End Select Next Application.ScreenUpdating = True End Sub -- Please remember to indicate when the post is answered so others can benefit from it later. "evilchrissy" wrote: I have a spreadsheet with around 20 columns. i want the filter button only on 10 of them. Easy enough if the columns are right next to eachother, i figured out how to do that. My problem is that i only want the filter buttons on columns a, c, e, f, h, l, and p. (these aren't the real columns, just an example.) If it were up to me, i'd either leave all the buttons showing, or move the columns i want filtered right next to eachother. The problem with that is it's not up to me (I'm working on this spreadsheet for three different supervisors and they have dictated the order they want to see the columns in, and seeing the filter button at the top of columns they do not want to filter annoys them.) If I can't have the filter button on selective non-adjacent columns, is there a way i could 'hide' the button on the columns that my bosses don't want to see the filter button on? Thanks in advance, any help would be appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table filters, especially DATE filters | Excel Worksheet Functions | |||
How to clear all filters in worksheet for all columns | Excel Discussion (Misc queries) | |||
Filters, Subtotal & Intacted Results after the filters' Removal | Excel Discussion (Misc queries) | |||
Selective stacking of columns in a chart | Excel Discussion (Misc queries) | |||
How do i move the filters from the columns on line one to the col. | Excel Worksheet Functions |