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 ...

To start the Disk Cleanup tool and specify the hard disk to be cleaned by using the command line, follow these steps: Click Start, and then click Run. In the Open box, type the following command, and then press Enter: c:\windows\SYSTEM32\cleanmgr.exe /d Drive Note In this command, the placeholder Drive represents the drive letter of the hard ...

In Outlook 2016, choose File. Choose Account Settings > Account Settings. On the Email tab, choose your account (profile), and then choose Repair. Note: The Repair option isn't available if you're using Outlook 2016 to connect to an Exchange account. Follow the prompts in the wizard, and when you’re done, restart Outlook.

The enablement package is a great option for installing a scoped feature update like Windows 10, version 20H2 as it enables an update from version 2004 to version 20H2 with a single restart, reducing update downtime. This enables devices to take advantage of new features now. For version 2004 devices that receive updates directly from Windows ...

Curate your notifications. Windows Security will send notifications about the health and safety of your device. You can turn these notifications on, or off, on the notifications page. In Virus & threat protection, under Virus & threat protection settings, select Manage settings, scroll down to Notifications and select Change notification settings.

On Windows, Mac, and Android Microsoft Defender can check files or apps you download and install, as well as run scans of files already on your system to spot any malware that may threaten your device. To learn more about anti-malware see Getting started with anti-malware in Microsoft Defender. Tip: Stay up-to-date and install the latest ...

Rename the file. You can rename the file (or request that the sender rename the file) to use an extension that Outlook doesn't block. For example, you can rename file.exe to file.docx. Once the renamed file is sent (or received), save it and rename it with the original extension using the following steps. Locate the attachment in the email message.

From the Inbox, select New Items > More Items > Outlook Data File. Enter a File name. To add a password, check the Add Optional Password box. Select OK. Type a password in both the Password and Verify Password text boxes and select OK again. If you set a password, you must enter it every time that the data file is opened — for example, when ...

Enter windows update, select Windows Update, and then select Installed Updates. In the list of updates, locate and select KB5002306, and then select Uninstall. Go to Start, enter Run, and then select Run. Enter Appwiz.cpl, and then select OK. Select View installed updates.

You'll need: A OneDrive storage location. Internet access. Move files to a new Windows PC using an external storage device. You'll need: An external hard drive or network drive. Note: If you're moving from a Windows 7 PC rather than a Windows 10 PC, see Moving to a Windows 10 PC for info on how to bring your files with you.