Can you Filter Horizontally in Excel? | Can You Filter Rows Instead of Columns in Excel? | 3 Methods

Are you able to filter horizontally in Excel? The answer to this question is: not really! However, there are some workarounds, none of which require a VBA macro.

1) Use custom views
2) Use copy-paste transpose
3) Use the FILTER function available in Excel 365
------------------------

[Sameer-itqu]

Life saver
No other video address these issue on YouTube

[Oak_]

Been looking for this explanation for hours, clear and straight to the point. Thanks!

[RedFoxTeh]

Great video! I'd be happy with just the first method, but you've presented 3! Thank you!
Also one can even instead of typing the departments in the cell, especially when the departments data is fixed, use drop down list using data validation.

[billknauss]

I didn't even know the transpose function existed. Thank you so much!

[michaelhaack]

Thanks. Great on the point answer and options. Great job

[IvanCortinas_ES]

Excellent. A good combination FILTER + TRANSPOSE. Thank you for this tutorial!!

[muhammedfayaz]

The last option is very useful, thanks for the video :)

[soll]

Thanks a million! Transpose was the way to go for me, and was so very simple to use.
Thank you for this video ! Subscribed to the channel now, there is more awesome content I need to review here.

[nudger]

Nice workaround and slightly less faff than creating a pivot table and slicers.

[everclearacg]

Is there a way for the values to returned horizontally?

[michaelhaack]

Thanks. Great on the point answer and options. Great job