Filter rows (non pivot)

[macandal]

How do I filter rows in Office 2010?

Thank you.

 

[Fluff]

Either with Autofilter or Advanced filter.

 

[macandal]

Either with Autofilter or Advanced filter.

But how? I've been trying to do it without success.

Thanks.

 

[Fluff]

As you haven't given us much to go on, have a look here https://spreadsheeto.com/filters/

 

[macandal]

As you haven't given us much to go on, have a look here https://spreadsheeto.com/filters/

What would you like to know? This is not a pivot table and I want to filter rows instead of columns. Let me know what else you would like to know.

Thank you.

 

[Fluff]

Do you mean you want to show/hide columns rather than rows?

 

[macandal]

Do you mean you want to show/hide columns rather than rows?

The data I want to filter goes across (left to right) my list as opposed of the "normal" top to bottom.

 

[Fluff]

In that case you will need VBA.
If you interested in that you will need to supply some sample data, along with an explanation of what you are trying to do.
There are some add-ins here that will enable you to post data to the thread. https://www.mrexcel.com/forum/about-board/508133-attachments.html