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 table, you can either reapply a filter to get up-to-date results, or clear a filter to redisplay all of the data.

Note: In earlier versions of Outlook, IMAP accounts also used an Outlook Data File (.pst).In Outlook 2016 and Outlook for Microsoft 365, IMAP accounts use Offline Outlook Data Files (.ost). You can also use an Outlook Data File (.pst) to backup or export items from any type of email account.

Note: The Not a value option in the field list refers to fields that are not normally summed or averaged.For example, you wouldn't sum the years displayed, but you might sum the values of the years displayed. If used with another field that is summed or averaged, Not a value works like a row label, but if used by itself, Not a value counts unique values of the selected field.

Compress the file. When you compress, or zip, your file, it decreases its size, and it might decrease it enough to fit within the Outlook size limits for attachments.The following articles describe how to compress and extract files for different Windows operating systems.

If you don't want to use OneDrive, the easiest solution is to unlink it. Follow the steps in Turn off, disable, or uninstall OneDrive, for how to unlink, hide, and uninstall OneDrive from your PC.

Notes: The formatting options that appear in the Formatting tab depend on the data you have selected. If your selection contains only text, then the available options are Text, Duplicate, Unique, Equal To, and Clear.When the selection contains only numbers, or both text and numbers, then the options are Data Bars, Colors, Icon Sets, Greater, Top 10%, and Clear.

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

The new Microsoft Edge will delete your browsing history, cookies, and site data, as well as passwords, addresses, and form data when you close all InPrivate windows. You can open an InPrivate window in different ways: Select and hold (right-click) the Microsoft Edge logo in the taskbar and select New InPrivate window.

Update RECENT GAMES: Once you have used the shortcut and launched Xbox Cloud Gaming (Beta) at least once, it will appear in the RECENT GAMES section (again, within the desktop Steam client) with a blank background.Just as before, right-click, select Manage > Set custom artwork, navigate to your artwork and select Xbox_Cloud_Gaming_Capsule.jpg.

Note: To let a user enter percentages, for example 20%, select Decimal in the Allow box, select the type of restriction that you want in the Data box, enter the minimum, maximum, or specific value as a decimal, for example .2 , and then display the data validation cell as a percentage by selecting the cell and clicking Percent Style in the Number group on the Home tab.