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
Office にサインインする - Microsoft サポート
Web ブラウザーから www.office.com にサインインして、Web 上のアプリの使用を開始するか、OneDrive などのアカウントに関連付けられている他の Web サービスにアクセスします。. インストールされている Office アプリにサインインする方法は、デバイスによって異なります。
Applies To: Excel for Microsoft 365, Word for Microsoft 365, Outlook for Microsoft 365, PowerPoint for Microsoft 365, Access for Microsoft 365, OneNote for Microsoft 365, Project Online Desktop Client, Publisher for Microsoft 365, Visio Plan 2, Excel for Microsoft 365 for Mac, Word for Microsoft 365 for Mac, Outlook for Microsoft 365 for Mac, PowerPoint for Microsoft 365 for Mac, OneNote for Microsoft 365 for Mac, Excel for the web, Word for the web, OneNote for the web, PowerPoint for the web, Excel 2021, Word 2021, Outlook 2021, PowerPoint 2021, Access 2021, Project Professional 2021, Project Standard 2021, Publisher 2021, Visio Professional 2021, Visio Standard 2021, Excel 2021 for Mac, Word 2021 for Mac, Outlook 2021 for Mac, PowerPoint 2021 for Mac, OneNote 2021 for Mac, Office 2021 for Mac, Excel 2019, Word 2019, Outlook 2019, PowerPoint 2019, Access 2019, Project Professional 2019, Project Standard 2019, Publisher 2019, Visio Professional 2019, Visio Standard 2019, Excel 2019 for Mac, Word 2019 for Mac, Outlook 2019 for Mac, PowerPoint 2019 for Mac, OneNote 2019 for Mac, Office 2019 for Mac, Excel 2016, Word 2016, Outlook 2016, PowerPoint 2016, Access 2016, OneNote 2016, Project Professional 2016, Project Standard 2016, Publisher 2016, Visio Professional 2016, Visio Standard 2016, OneNote for Mac, Microsoft 365 for home, Office for business, Office 365 Small Business, Microsoft 365 admin, Project Online, Microsoft 365 for Mac
Change or reset your password - Microsoft Support
Important: Microsoft accounts, the Windows operating system, and other Microsoft products include passwords to help secure your information.This article provides some options that you can use to reset or recover your password if you forget it. Be aware that, if these options don’t work, Microsoft support can't help you retrieve or circumvent a lost or forgotten password.
Protect yourself from phishing - Microsoft Support
First time, infrequent senders, or senders marked [External] - While it's not unusual to receive an email or Teams message from someone for the first time, especially if they are outside your organization, this can be a sign of phishing.Slow down and take extra care at these times. When you get an email or a Teams message from somebody you don't recognize, or that Outlook or Teams identifies ...
Lock or unlock specific areas of a protected worksheet
Users can't sort ranges that contain locked cells on a protected worksheet, regardless of this setting. Use AutoFilter. Using the drop-down arrows to change the filter on ranges when AutoFilters are applied. Users cannot apply or remove AutoFilters on a protected worksheet, regardless of this setting. Use PivotTable reports
Applies To: Excel for Microsoft 365, Excel 2021, Excel 2019, Excel 2016
Change the email address or phone number for your Microsoft account
Email addresses and phone numbers associated with your Microsoft account are called aliases and they use the same contacts, online storage, subscriptions, and account settings.
Applies To: Microsoft account dashboard
Microsoft 365 Training
Get productive quickly with Microsoft 365 videos and tutorials. Explore Microsoft 365 training guides and tips to collaborate with anyone, anywhere.
Microsoft 365 help & learning
Get Microsoft 365 support, help, and learning resources. Organize your life, expand your creativity, and protect what’s important with Microsoft 365
Applies To: Office 2021, Office 2021 for Mac, Office 2019, Office 2019 for Mac, Office 2016, Microsoft 365 for home, Microsoft 365 for Mac, Microsoft 365 for Windows
What to do if Microsoft Edge isn't working - Microsoft Support
If you can't open Microsoft Edge, or if it opens briefly and then closes, or if you’re unable to open specific webpages, here are some things you can try. Close other tabs, extensions, and apps. Your computer may have run out of memory and can't load the site while also running your apps, extensions, and programs.
Add or manage an iCloud email account in Outlook
If two-factor authentication isn't set up, you should be able to use your regular password. Enter your password and select Connect. However, if two-factor authentication is set up, you'll need to generate an app-password. Follow the steps in the section Outlook won't accept my password.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016, New Outlook for Windows