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

Junk e-mail messages, also known as spam, can be a nuisance in your Inbox.The Junk E-mail Filter in Outlook identifies messages that are likely junk and moves them to the Junk E-mail folder. You can easily change the level of junk email protection or automatically delete junk email.

It’s always good to stay on top of the content you’ve shared with friends, family, and collaborators. OneDrive makes it easy. Simply log into your account at OneDrive.com, and in the left-side navigation area, you’ll see a view called Shared.. This view lets you quickly see all of your content that’s shared, especially the content that you’ve shared with others.

Get started with Microsoft Teams (free). Explore your options, find out what’s new, browse help topics, and more.

Open directly from the Search bar. If the Bing Chat icon is displaying in your Search bar on the taskbar, simply select it and Bing Chat will open in Microsoft Edge.. Open in Search Home. Here's how: Select the Search icon or the Search bar on your taskbar.

To add a personal or work/school account to OneDrive on your pc. Open OneDrive settings (select the OneDrive cloud icon in your notification area, and then select the OneDrive Help and Settings icon then Settings.)

To see where your browser is saving downloads, look in your browser's settings. For example, in the new Microsoft Edge , select Settings and more > Settings > Downloads .The file path for your downloaded files (for example, C:\Users\[your name]\Downloads) is listed under Location.. In Microsoft Edge Legacy , select Settings and more > Settings .

What is a Microsoft account used for? You need a Microsoft account to sign in to your Windows pc, Xbox console, or any of Microsoft’s products and services, including Office, Outlook.com, OneDrive, Xbox Live, Microsoft 365, Family Safety, Skype, Bing, Microsoft Store and MSN.

Device Encryption is a Windows feature that enables BitLocker encryption automatically for the Operating System drive and fixed drives. It’s particularly beneficial for everyday users who want to ensure their personal information is safe without having to manage complex security settings.

Office for the web programs are included in most Microsoft 365 plans. Click a document, or use the three-dot Open Menu in a library to open Word, Excel, PowerPoint, OneNote, and PDF files in your browser. Outlook attachments and Lync Web App meeting notes also open in Office for the web.