Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

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

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

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.

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.

Export contacts out of other email services. Export iCloud contacts. Export Gmail contacts – See Gmail help. Export Yahoo contacts – See Yahoo import and export help. Export Thunderbird contacts – See Mozilla support.

The files on your OneDrive are private until you share them. Keep in mind that when you share folders with Edit permissions, people you share with can add the shared folders to their own OneDrive.. This lets them keep the folder alongside their own folders and items, easily move items between folders, and more easily work on it offline.

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

If you can’t locate a lost file from your backup, then you can use Windows File Recovery, which is a command line app available from the Microsoft Store.Use this app to try to recover lost files that have been deleted from your local storage device (including internal drives, external drives, and USB devices) and can’t be restored from the Recycle Bin.

Next to Reset this PC, select Reset PC and choose an option:. Keep my files—Reinstalls Windows 11 but keeps your personal files and any apps that came with your PC.This option removes changes you made to settings, as well as apps and drivers you installed.