Use AutoFilter or built-in comparison operators like "greater than" and “top 10” in Excel to show the data you want and hide the rest. Once you filter data in a range of cells or tables, you can either reapply a filter to get up-to-date results or clear a filter to redisplay all of the data. Learn more at the Excel Help Center: https://msft.it/6005pA31U
► Subscribe to Microsoft 365 on YouTube here: https://aka.ms/SubscribeToM365
► Follow us on social:
LinkedIn: / microsoft-365
Twitter: / microsoft365
Instagram: / microsoft365
Facebook: / microsoft365
► For more about Microsoft 365, visit https://msft.it/6006Tc8Z4
#Microsoft365 #MicrosoftExcel