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: https://www.linkedin.com/showcase/microsoft-365/
Twitter: https://twitter.com/Microsoft365
Instagram: https://www.instagram.com/microsoft365/
Facebook: https://www.facebook.com/Microsoft365/
► For more about Microsoft 365, visit https://msft.it/6006Tc8Z4
#Microsoft365 #MicrosoftExcel
► Subscribe to Microsoft 365 on YouTube here: https://aka.ms/SubscribeToM365
► Follow us on social:
LinkedIn: https://www.linkedin.com/showcase/microsoft-365/
Twitter: https://twitter.com/Microsoft365
Instagram: https://www.instagram.com/microsoft365/
Facebook: https://www.facebook.com/Microsoft365/
► For more about Microsoft 365, visit https://msft.it/6006Tc8Z4
#Microsoft365 #MicrosoftExcel
- Category
- Software
- Tags
- Microsoft, Office, Office 365
Sign in or sign up to post comments.
Be the first to comment