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

On the settings page for that app, change the setting for Let this app run in the background.Here’s a summary of each option: Always.The app is always allowed to run in the background—receive info, send notifications, and stay up to date—even when you’re not actively using it.

了解如何从 Windows 10 家庭版升级到 Windows 10 专业版或从 Windows 11 家庭版升级到 Windows 11 专业版，包括如何使用有效产品密钥或 Microsoft Store。

Choose number of pages to print per sheet: Printing multiple pages on a single sheet of paper is a useful technique to save paper, reduce printing costs, and create compact versions of your documents. The number of pages that can be printed on a single sheet depends on the capabilities of your printer and the printing options you choose (Example: 1, 2, 4, 6, 9 or 16 pages per sheet).

Important: You don't need to remove old security information unless there is an account security risk (e.g. someone else has access to your old mailbox).

Top of Page. Contacts (People) keyboard shortcuts. The People view is your address book in Outlook where your personal contacts are stored and where you can open any address book that has been set up for your organization. The People, Mail, and Calendar views work together so you can easily send mail to and schedule appointments with your most important people.

In Windows 11, ensure that Camera access, Let apps access your camera, and the individual toggle for the Microsoft Store app you wish to use is turned on. If you do not see the app or website you're looking for in the list, it's likely a desktop app. Desktop apps cannot be individually toggled, but access for those apps can be controlled using Let desktop apps access your camera.

The Snap feature is a great way to improve your productivity by sharing many app windows in a single screen. Different layouts are available with many sizes to choose from, so you can get the most from your favorite apps when you are working on specific tasks.

The new Microsoft Edge will delete your browsing history, cookies, and site data, as well as passwords, addresses, and form data when you close all InPrivate windows. You can open an InPrivate window in different ways: Select and hold (right-click) the Microsoft Edge logo in the taskbar and select New InPrivate window.

Note: If you are in tablet mode, you may not be able to see your desktop icons properly.You can find the program by searching for the program name in File Explorer. To turn off tablet mode, select action center on the taskbar (next to date and time), and then select Tablet mode to turn it on or off.