FILTER function - Microsoft Support
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 ("").
Applies To:
Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2021 for Mac, Excel for iPad, Excel for iPhone, Excel for Android tablets, Excel for Android phones
Windows Startup Settings (including safe mode) - Microsoft Support
Safe mode starts Windows with a minimal set of drivers and services to help troubleshoot issues. If a problem doesn't reappear when you start your PC in safe mode, you can eliminate the default settings and basic device drivers and services as possible causes.
Use Internet Explorer in Windows 10 - Microsoft Support
Internet Explorer 11 support ended on June 15, 2022. We recommend you use Microsoft Edge for a faster, more secure and more modern web browsing experience.
Format a date the way you want - Microsoft Support
When you enter some text into a cell such as "2/2", Excel assumes that this is a date and formats it according to the default date setting in Control Panel.Excel might format it as "2-Feb".If you change your date setting in Control Panel, the default date format in Excel will change accordingly.
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
Set up your Microsoft 365 sign-in for multi-factor authentication
By setting up MFA, you add an extra layer of security to your Microsoft 365 account sign-in. For example, you first enter your password and, when prompted, you also type a dynamically generated verification code provided by an authenticator app or sent to your phone.
Applies To:
Office for business, Microsoft 365 admin
Create an email message template - Microsoft Support
In the Save As dialog box, in the Save as type list, select Outlook Template.
Applies To:
Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016
Contact - Microsoft Support
Contact Microsoft Support. What's new. Surface Pro; Surface Laptop; Surface Laptop Studio 2
Sync OneDrive files and folders - Microsoft Support
Work with your files in your file system. Once you're synced, you’ll see your files in File Explorer. On a Mac, your files will appear under OneDrive in the Mac Finder.. If you use more than one account, your personal files appear under OneDrive – Personal and your work or school files appear under OneDrive - CompanyName.. You can copy or move files from your computer to OneDrive right ...
Applies To:
OneDrive (home or personal), OneDrive for Mac, OneDrive for Windows
Product Key für Windows finden - Microsoft-Support
Erfahren Sie, wie Sie einen Windows-Product Key für die Aktivierung finden und wann Sie stattdessen eine digitale Lizenz verwenden.
Applies To:
Microsoft account dashboard
Create and print a single envelope - Microsoft Support
Click the Printing Options tab.. The printer driver tells Word which way the envelope should be loaded into the printer, and this information is displayed in the Printing Options tab of the Envelope Options dialog box.. 1. The feed method determines the position of the envelope (right, middle, left) and whether the long or short edge is being fed into the printer.
Applies To:
Word for Microsoft 365, Word 2021, Word 2019, Word 2016, Word 2013