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

Notes: To reset other versions of OneDrive, read Reset OneDrive.If you're not sure which OneDrive app you have, read Which OneDrive app do I have?. Resetting OneDrive disconnects all your existing sync connections (including personal OneDrive and OneDrive for work or school if set up).

Make text bigger on your screen. If the text size feels too small when navigating through Windows, you can make the text bigger. This affects, for example, title bars, menus, and icon texts.

Select Start > Settings > Personalization > Colors, and then choose your own color, or let Windows pull an accent color from your background.. Change desktop colors

若要在 Outlook.com 中获取支持，请单击此处或选择菜单栏上的帮助，然后输入查询。 如果自助服务无法解决问题，请向下滚动到“仍需要帮助？”，然后选择“是”。 若要在 Outlook.com 中联系我们，需要登录。

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.

Get help and learn how to use Skype with Microsoft's official support page.

Select the level of tracking prevention that’s right for you: Basic: Blocks potentially harmful trackers but allows most other trackers and those that personalize content and ads. Balanced (Recommended): Blocks potentially harmful trackers and trackers from sites you haven’t visited.Content and ads will likely be less personalized. Strict: Blocks potentially harmful trackers and most ...

Battery Life: Lowering your refresh rate can save battery power by reducing the amount of energy your display consumes.This can be useful when you are using a laptop or tablet and want to extend your battery life.

Chat: If you wish to guarantee Chat is turned off for a given PC, you can do so by mapping www.bing.com to either Nochat.bing.com (which will lock Chat as turned off for the given PC) or Nochatstrict.bing.com (which will lock Chat as turned off for the given PC and the SafeSearch setting as locked to strict), by following the same steps as outlined above but in step 6, pinging either “nochat ...