FILTER function - Microsoft Support
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, return an empty string ("").
Applies To:
Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2021 for Mac, Excel for iPad, Excel for iPhone, Excel for Android tablets, Excel for Android phones
Microsoft Rewards regions - Microsoft Support
Australia Bangladesh Bhutan British Indian Ocean Territory Brunei Cambodia China Hong Kong India Indonesia Japan Kyrgyzstan Laos Macau Malaysia Maldives
Applies To:
Microsoft account dashboard
Change your profile picture in Microsoft Teams
Select your profile picture at the top right of Teams. When your account manager opens, select your profile picture again.
Applies To:
Microsoft Teams
Share OneDrive files and folders - Microsoft Support
The files on your OneDrive are private until you share them. Keep in mind that when you share folders with Edit permissions, people you share with can add the shared folders to their own OneDrive.. This lets them keep the folder alongside their own folders and items, easily move items between folders, and more easily work on it offline.
Applies To:
OneDrive for Business, SharePoint Server Subscription Edition, SharePoint Server 2019, SharePoint Server 2016, SharePoint Server 2013 Enterprise, SharePoint in Microsoft 365, Office for business, Microsoft 365 admin, OneDrive (work or school), OneDrive (home or personal), SharePoint in Microsoft 365 Small Business
KB4023057: Update Health Tools—Windows Update Service components
Important: If your device is out of support, it is no longer receiving security updates from Microsoft and may become more vulnerable to security risks and viruses.Therefore, we strongly recommend that you update to the latest version of Windows. Each version of Windows is supported for 18 months.
Update to the new Microsoft Edge - Microsoft Support
To change appearance, select Appearance and make the changes you want to your default theme, zoom, toolbar, and fonts.
How to go passwordless with your Microsoft account
Going passwordless refers to removing your password and using a passwordless method to sign in instead. Passwordless solutions such as Windows Hello, the Microsoft Authenticator app, SMS or Email codes, and physical security keys provide a more secure and convenient sign-in method. While passwords can be guessed, stolen, or phished, only you can provide fingerprint authentication, or provide ...
Applies To:
Microsoft account dashboard
Manage app permissions for your camera in Windows
To use your camera with apps on Windows 11, you'll need to turn on some permissions in Camera settings. Then, you'll need to check your app permissions if you want to use your camera with apps.
Add or remove an email alias in Outlook.com - Microsoft Support
To get support in Outlook.com, click here or select Help on the menu bar and enter your query. If the self-help doesn't solve your problem, scroll down to Still need help? and select Yes.. To contact us in Outlook.com, you'll need to sign in.
Applies To:
Outlook.com
Edit photos and videos in Windows - Microsoft Support
Blur. Select the Blur option, then use the slider to adjust the Blur intensity, then select Apply to blur the background.. Remove. Select the Remove option, then select Apply to remove the image background.. Replace. Select the Replace option, then use the color palette to select the background color. Alternatively, you can specify the RGB values for the desired color.