special characters<\/a>.<\/p>\n\n\n\nThe asterisk (*) character represents a variable number of\ncharacters (from zero to infinity), and the question mark (?), which represents\na single character.<\/p>\n\n\n\n
Here\u2019s how it works. Let\u2019s say that you want to find a name that begins with the letter a<\/strong>.<\/p>\n\n\n\n <\/figure>\n\n\n\nBut the same effect you would get if you use the option Begins With<\/strong>. That\u2019s true, so let\u2019s check something a bit more complicated.<\/p>\n\n\n\nLet\u2019s display all names that begin with the letter a<\/strong>, and end with the letter a<\/strong>. Let\u2019s modify our example and see what you can get.<\/p>\n\n\n\n <\/figure>\n\n\n\nThe same effect you can achieve with the following Custom AutoFilter<\/strong>.<\/p>\n\n\n\n <\/figure>\n\n\n\nAnd this is the result.<\/p>\n\n\n\n <\/figure>\n\n\n\nLet\u2019s see how the question mark works as a wildcard\ncharacter.<\/p>\n\n\n\n
In the next example, we are going to display names that start with a, and end with a, but this time add another restriction \u2013 names should have 6 characters.<\/p>\n\n\n\n
Here\u2019s what it looks like.<\/p>\n\n\n\n <\/figure>\n\n\n\nNow, the filter displays only rows with these two names: Albina<\/strong> and Alisha<\/strong>.<\/p>\n\n\n\nYou can also use the wildcard characters inside Custom AutoFilter<\/strong>. They are easy to use\nand make our work much easier.<\/p>\n\n\n\nClearing Filters<\/h2>\n\n\n\n After you applied a filter, it\u2019s time to clear them. You can clear a single filter, or you can clear it all at once.<\/p>\n\n\n\n
To clear a single filter, click the filter icon, and navigate to Clear Filter From<\/strong>. In our case, it will be the First Name<\/strong>.<\/p>\n\n\n\n <\/figure>\n\n\n\nIf you have more than one filter applied, you can remove them one by one, or clear them all at once.<\/p>\n\n\n\n
Here\u2019s how to do it.<\/p>\n\n\n\n
Navigate to Home >> Editing >> Sort & Filter >> Clear<\/strong>.<\/p>\n\n\n\n <\/figure>\n","protected":false},"excerpt":{"rendered":"Filters in Excel are used to reduce the amount of data displayed inside a worksheet. Depending on whether you filter text, numbers, or…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[21],"tags":[170,190],"yoast_head":"\n
Filter a Table in Excel<\/title>\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n\t \n\t \n\t \n