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.

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

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.

Receive photos, videos, or other kinds of files that you or a friend shares from another device, such as a phone, laptop, or tablet. On your PC, select Start > Settings > Devices > Bluetooth & other devices. Learn how to pair.

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.

To change appearance, select Appearance and make the changes you want to your default theme, zoom, toolbar, and fonts.

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.

Notes: Reinstalling Windows 11 using installation media while choosing to ‘Keep nothing’ (a clean install) will automatically enable reserved storage if the partition you reinstall Windows to is 20GB or larger. Reserved storage sets aside disk space to be used by updates, apps, temporary files, and system caches, thus improving the day-to-day function of your PC by ensuring that critical ...

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