View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Bernie Deitrick Bernie Deitrick is offline
external usenet poster
 
Posts: 5,441
Default Autofilter across a single row -- is this possible? (repeat, sorry

If you mean to only show values in a row that correspond to some criteria, and hide columns, then
no, not without a macro. The best solution in that case would be to transpose your data table.

HTH,
Bernie
MS Excel MVP


"a0xbjzz" wrote in message
...
Hi, I'm hoping there is some way to filter across a row, as opposed to a
single column. Can this be done with autofilter? If it can, I'm not doing it
right, so please help!