In how can i filter multiple columns simultaneously in Excel

I'm attempting to filter columns E, G, and I all at the same time. I need to
display rows that have values greater than 0 in any one of those three
columns. So far I can only filter progressively. If I filter column E and
then filter column G, the second filter is only applied to the results of the
first filter.

Does anybody know if it's even possible to do what I'm trying to do?

Answer:

use the advance filtering option or type in the M column for example =OR(E1>0;G1>0;I1>0)

 Other excel answers

 

 

You can find similar Excel Questions and Answer hereunder

1) How can I find the count of records that meet multiple conditions in my raw data table?

2) How can I sort data using VBA?

3) Vlookup to return max value from multiple hits in Excel

4) How can I enter multiple lines of data in a cell?

5) Excel 2010 vba replacement of application filesearch in Excel

6) Split string into multiple columns in Excel

7) How to hide and unhide rows and columns in Excel

8) How can I filter a table to get all records that have less than a particular value in a specific column?

9) Vlookup to return multiple values in same cell in Excel

10) How to hide and unhide rows and columns in excel VBA

 

Here the previous and next chapter