FILTER function. Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel for the web More... The FILTER function allows you to filter a range of data based on criteria you define. In the following example we used the formula =FILTER (A5:D20,C5:C20=H2,"") to return all records for Apple, as selected in cell H2, and if there are no apples ...

Go to Settings > Connected Devices > Link to Windows > About Link to Windows . or. Swipe downwards from the top of your screen to reveal the Quick Panel, and then select Link to Windows > About Link to Windows . If an update is available, select Update. Wait for the update to complete successfully, then close and reopen the app.

To find out which version of Windows your device is running, press the Windows logo key + R, type winver in the Open box, and then select OK. Here’s how to learn more: Select Start > Settings > System > About . Open About settings. Under Device specifications > System type , see if you're running a 32-bit or 64-bit version of Windows.

When you enable an add-in, it adds custom commands and new features to Microsoft 365 programs that help increase your productivity. Because add-ins can be used by attackers to do harm to your computer, you can use add-in security settings to help protect yourself.

Enable virtualization on Windows 11 PCs. Virtualization lets your PC emulate a different operating system, like Android™ or Linux. Enabling virtualization gives you access to a larger library of apps to use and install on your PC. If you upgraded from Windows 10 to Windows 11 on your PC, these steps will help you enable virtualization.

This article is for Outlook.com. If you're using Outlook for Windows, see Fixes or workarounds for recent issues in Outlook for Windows.. If you're having problems accessing Outlook.com, you can see the status of Microsoft Office Online Services at the Service Health portal.. If you're having problems sending or receiving email, read how to Fix Outlook.com email sync issues.

To clear your TPM, follow these steps: Go to Start > Settings > Update & Security > Windows Security > Device security . Under Security processor, select Security processor details. Select Security processor troubleshooting, and then under Clear TPM, select Clear TPM. You'll need to restart your device to complete the process.

Select your version of Microsoft 365 below to learn how to activate Microsoft 365. Activate Microsoft 365 or a non-subscription version of Office. Activate Office that's pre-installed on a new Windows device. Activate an Office purchase or offer that's included on a new Windows device. Activate Office from Microsoft Workplace Discount Program.

Find out which version of Microsoft Edge you have. Here's how: Open the new Microsoft Edge , select Settings and more at the top of the window, and then select Settings . Scroll down and select About Microsoft Edge. Note: This topic is for the new Microsoft Edge . Get help for the legacy version of Microsoft Edge .

To get a theme, expand one of the categories below, select a link for the theme, and then select Open. This saves the theme to your PC and puts it on your desktop. If you prefer, some themes can also be installed from the Microsoft Store. Explore themes in the Microsoft Store. Get free Windows themes from Microsoft to personalize background ...