Autofilter to hide collumns instead of rows

[RedSoniq]

Instead of using autofilter to hide rows from the view, I want it to
hide collumns from the view. (Working horizontal instead of vertical,
so to speak.

For example:

Availabiltiy of products

productname | 1 | 2 | 3
france
germany
UK

 

[tclohesy]

Not sure if this'll help much, but:

normally it is better to lay out data with titles across the top, a
there are generally more data items than there are titles, and yo
would be limited to 256 data items.

If you only want to filter in this way because of the data you alread
have, you might want to transpose (not sure how much data you ca
transpose at a time, but have a go):

Highlight all the data and go to Copy, then click on the cell at th
top-left of where you want the table (probably on a new sheet would b
most sensible) and right click>Paste Special. Choose the Transpos
tick-box at the bottom.

Hope this is some help,

Ton

 

[Randy]

you can simply highlight the columns, across the column
headers) then right click on one of the highlighted
comlumns and choose "Hide".

If you want to buttonize this. just record the manual
process with the macro recorder, create a button and
assign the macro you recorder to the button.

 

[Dave Peterson]

You might want to try Data|Group with columns that could be hidden all together.