Filter by using advanced criteria - Microsoft Support
If the Excel data you want to filter requires complex criteria you can filter by using advaned criteria.
Applies To: Excel for Microsoft 365, Excel 2021, Excel 2019, Excel 2016
Phone Link requirements and setup - Microsoft Support
We recommend always having the latest version of Windows installed to make sure you get the best experience with the Phone Link .
Open and use a shared mailbox in Outlook - Microsoft Support
Learn how to open a shared mailbox in Outlook. Shared mailboxes let a group of users view and send email, and share a calender, and open a contact list from a common mailbox.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016, Office 365 Small Business, Microsoft 365 admin, Outlook on the web, New Outlook for Windows
SUMIF function - Microsoft Support
How to use the SUMIF function in Excel to add the values in a range that meet criteria that you specify.
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2019 for Mac, Excel 2016
Add or remove items from a drop-down list - Microsoft Support
Edit a drop-down list that's based on an Excel Table. If you set up your list source as an Excel table, then all you need to do is add or remove items from the list, and Excel will automatically update any associated drop-downs for you.. To add an item, go to the end of the list and type the new item.
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2019 for Mac, Excel 2016
Reset a forgotten Microsoft account password
Learn how to reset or change your Microsoft account password. Get help with a forgotten Microsoft account password.
Applies To: Microsoft account dashboard
Troubleshoot Outlook email setup - Microsoft Support
Learn how to troubleshoot and fix problems setting up your email in Outlook.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016, Microsoft 365 admin
Lock or unlock specific areas of a protected worksheet
How to lock cells in Excel to protect your data. You can also unlock a range of cells and grant permissions to others to edit.
Applies To: Excel for Microsoft 365, Excel 2021, Excel 2019, Excel 2016
Download Office language interface packs (LIP) - Microsoft Support
Download Office language interface packs (LIP) By pressing submit, your feedback will be used to improve Microsoft products and services.
Keyboard shortcuts in Windows - Microsoft Support
Learn how to navigate Windows using keyboard shortcuts. Explore a full list of taskbar, command prompt, and general Windows shortcuts.