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

Select Add a keyboard and choose the keyboard you want to add. If you don't see the keyboard you want, you may have to add a new language to get additional options. If this is the case, go on to step 4.

Right-click the app, select More, and then select Open file location.This opens the location where the shortcut to the app is saved. If there isn't an option for Open file location, it means the app can't run at startup.

The Health report starts off by showing you the last time a Device Health scan was run. The time displayed should be basically the current time, as Windows Security tries to run a Device Health scan when you open the Device performance & health page.. Beyond the time of last scan you'll see the status of the key areas that Device Health monitors:

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

Note: If you see the icon next to the On/Off toggle for an app, you can select it to see the registry location that contains the path for the app. Apps installed through Microsoft Store (.MSIX apps) don’t have these icons. If you select the icon for these apps, File Explorer opens and highlights the executable file.

Select Start > Settings > Personalization.The preview window gives you a sneak peek of your changes as you make them. In Personalize your background, you can select a picture, a solid color, or a slideshow of pictures you create.Or you can choose Windows spotlight to see a new image from around the world every day.

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.

Note: If you forgot your account info and had to reset your security info, you must wait 60 days before closing your account.

Under Edit signature, compose your signature.You can change fonts, font colors, and sizes, as well as text alignment. If you want to create a more robust signature with bullets, tables, or borders, use Word to create and format your signature text, then copy and paste it into the Edit signature box.You can also use a pre-designed template to create your signature.