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 ("").

Unlinking and re-linking your computer to OneDrive can help solve some sync problems. You can also use these same steps to move your OneDrive to a new location, such as an external disk drive.

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.

In PowerPoint 2016, you can insert an online video with an embed code or search for a video by name. Then you can play it during your presentation.

Select your gamerpic icon in the bottom menu on the Xbox app to get to the Profile tab.; Select the edit icon next to your gamerpic at the top of the screen.

To learn more about changing mic settings in Microsoft Teams (free), see Manage your device settings in Microsoft Teams (free). Check your microphone. Some devices have a physical mute option on the device itself, so check that your headphone boom is not in the mute position (usually upright or away from your mouth), or that your external mic's physical mute button is not turned on.

Select Create a password reset disk, and follow the remaining instructions

The Microsoft Edge feature that blocks pop-ups is effective in preventing websites from automatically opening a new window or tab, or a partial window on top of your current web page. This feature is turned on by default. There are many different types of pop-ups, including advertisements, notices, offers, or alerts that can appear at various times on any web page. Some can be helpful, such as ...

Optimizations for windowed games improves gaming on your PC by using a new presentation model for DirectX 10 and DirectX 11 games that appear in a window or in a borderless window.

If you want to secure your content and get a link that only works for the people you invite, select Specific people in Link settings when creating the sharing link.. The recipients' experience depends on the settings you select when creating the sharing link, and the account they use to view the file.