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

Find out how to view the printer queue in Windows.

The Office app is running in the background. If the file is not shared on a network or if you are certain that no one is currently editing it, then an instance of the Office app with the file open might be running in the background.

Help to decide whether you should install the 32-bit Office version or the 64-bit Office version. Which version is right for you depends on how you plan to use Office. Find out about choosing between 32-bit Office and 64-bit Office.

Learn how to troubleshoot File Explorer problems in Windows. To open File Explorer in Windows 10, select its icon on the taskbar, press the Windows logo key + E on your keyboard, or select Start > Documents (directly beneath your user icon).. Here are some things to try if File Explorer won't open.

In Outlook, you have the option to: Attach a file | Upload a locally saved file to your OneDrive | Insert a picture into the body of a message | Attach an email item | Solve problems with attachments. Attach a file to an email message in new Outlook. New Outlook keeps track of the files you have worked on recently and suggests them whenever you decide you want to attach a file to an email message.

Check the Device Manager. Right-click the Start button and select Device Manager.. Check to see if any devices are marked with the exclamation point (!). Right-click the device and select Update driver.. If updating the driver doesn’t help, try disabling or uninstalling the device.

If you reference a Checkbox cell with a formula, TRUE or FALSE will be passed along to that formula. For example, if you have a Checkbox in cell A1, you can use a formula like =IF(A1, "Checked", "Unchecked") to display a custom message based on the Checkbox's state.

Important: you should limit the number of administrators on your Windows device because administrators have complete control over the system.Administrators can change settings, install software, and access all files. If too many people have this level of access, it could lead to security risks like malware installation or unwanted changes to your system.

If you think someone might have unauthorized access to your account, we can protect you by signing you out from all of your trusted devices. Within 24 hours, you will be signed out of browsers, apps and anywhere else your account is used to sign in, except an Xbox console.