Hi all
Many thanks in advance for any help that can be afforded to me. I have searched for dynamic filter in this forum, but I'm looking for a specific outcome and I'm not versed enough in the Excel language/terminology to be able to work out which posts I find can help me, so apologies if this is already covered.
I'm not an expert in Excel, I do know some basic ways to filter, and I have found a YouTube video that partly answers my questions. If you look at the first five seconds of the video linked below, the gentleman types into the search box and it immediately hides all rows that do not contain the letters being typed, but only for the first column. I would like to achieve this filtering but for a spreadsheet that has 20 columns, with data in all of them. So for example, if I have the name Smith appearing in various rows, and columns, the search will still capture this word and hide irrelevant rows regardless of what column the word or numbers being typed appear in. So the letter S will hide all the rows that don't have this, then SM, only the rows that contain SM, then SMI, SMIT, etc.
Does anyone know of an easy to follow YouTube tutorial that does this? I've found a few that filter data into a different part of the spreadsheet, and focus on just one or two columns, but I don't want this, I'd like the rows of data to stay as they are, and the irrelevant ones simply hide, when the search letters appear in any of the columns, not just one or two.
Again, all help appreciated.
Paul
Many thanks in advance for any help that can be afforded to me. I have searched for dynamic filter in this forum, but I'm looking for a specific outcome and I'm not versed enough in the Excel language/terminology to be able to work out which posts I find can help me, so apologies if this is already covered.
I'm not an expert in Excel, I do know some basic ways to filter, and I have found a YouTube video that partly answers my questions. If you look at the first five seconds of the video linked below, the gentleman types into the search box and it immediately hides all rows that do not contain the letters being typed, but only for the first column. I would like to achieve this filtering but for a spreadsheet that has 20 columns, with data in all of them. So for example, if I have the name Smith appearing in various rows, and columns, the search will still capture this word and hide irrelevant rows regardless of what column the word or numbers being typed appear in. So the letter S will hide all the rows that don't have this, then SM, only the rows that contain SM, then SMI, SMIT, etc.
Does anyone know of an easy to follow YouTube tutorial that does this? I've found a few that filter data into a different part of the spreadsheet, and focus on just one or two columns, but I don't want this, I'd like the rows of data to stay as they are, and the irrelevant ones simply hide, when the search letters appear in any of the columns, not just one or two.
Again, all help appreciated.
Paul