Autofilter to hide collumns instead of rows

  • Thread starter Thread starter RedSoniq
  • Start date Start date
R

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
 
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
 
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.
 
Back
Top