The FILTER function allows you to filter a range of data based on criteria you define.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Learn how to access Microsoft Store on Windows by selecting the icon on the taskbar or using the search box.

Other ways to open these file types. You can also right-click or double-click the .eml, .msg, or .oft file to open them in new Outlook. Right-click

Note: If you're an IT admin, managing Surface for Business devices in your organization, see Recovery tool (Surface IT Toolkit) for another way to restore a supported Surface device to its factory state.

Issues that are fixed in this update. The following issues are fixed for .NET Framework 4.7.2. SQL Server (SQL) Fixes an issue in which the .NET Framework API SqlConnection.ConnectionString property is used to set a null or empty connection string. In this situation, a Null Reference Exception (NRE) occurs when you use the API together with .NET Framework 4.7.2.

If you are having trouble with the camera in Microsoft Teams, we have some suggestions to help you get back on track. Solutions include: closing camera-related apps, updating device drivers, checking privacy settings.

Workbook passwords can be changed or removed by anyone who knows the current password.

For a black screen, use the following keyboard shortcut: Windows logo key + Ctrl + Shift + B.

When prompted, enter the product key. You can find the product key on the sticker on the CD case or other packaging. If you need help, see Find your Product Key for Office 2007.