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
Block or unblock senders in Outlook - Microsoft Support
Notes: If you have existing lists of safe names and addresses, you can move that information into Outlook. Click Import from File and browse for the list file that you want. To create a file that uses your current list, click Export to File and then specify where you want the new file saved.. To change a name on the list, click the name that you want to change and then click Edit.
Applies To: New Outlook for Windows
About Microsoft Authenticator - Microsoft Support
Microsoft Authenticator is a free app that helps you sign in to all your accounts without using a password - just use a fingerprint, face recognition, or a PIN.
Applies To: Microsoft account dashboard
When trying to install updates from Windows Update you might receive ...
Symptom. When trying to install updates from Windows Update you might receive "Updates Failed, There were problems installing some updates, but we'll try again later" with one of the following errors:
安装 Windows 11 的方法 - Microsoft 支持
有关详细信息,请参阅让电脑焕然一新。 重要: 在选择从媒体启动之前,应验证设备是否满足最低系统要求,因为满足后才允许安装 Windows 11,如果你至少具有 TPM 1.2(而不是最低系统要求的 TPM 2.0),它将不会根据处理器的系列和模型验证处理器是否在批准的 CPU ...
Turn off Scroll Lock - Microsoft Support
Tip: To quickly open the On-screen Keyboard in Windows 11, click the Windows button.Begin typing On-Screen Keyboard which will appear in the search entry box. Under Search, which will appear as a list above the search box, click the On-Screen Keyboard search result. When the on-screen keyboard appears, click the ScrLk button.
Applies To: Excel for Microsoft 365, Excel 2021, Excel 2019, Excel 2016
Format text as superscript or subscript in Word - Microsoft Support
For superscript, press Ctrl, Shift, and the Plus sign (+) at the same time. For subscript, press Ctrl and the Equal sign (=) at the same time. (Do not press Shift.)
Applies To: Word for Microsoft 365, Word for Microsoft 365 for Mac, Word for the web, Word 2021, Word 2021 for Mac, Word 2019, Word 2019 for Mac, Word 2016
Office Help & Training
We would like to show you a description here but the site won’t allow us.
Combine text and numbers - Microsoft Support
Examples. See various examples in the figure below. Look closely at the use of the TEXT function in the second example in the figure. When you join a number to a string of text by using the concatenation operator, use the TEXT function to control the way the number is shown. The formula uses the underlying value from the referenced cell (.4 in this example) — not the formatted value you see ...
Applies To: Excel for Microsoft 365, Excel 2021, Excel 2019, Excel 2016
Other email accounts like Gmail and Yahoo not working in Outlook.com
New or classic Outlook for Windows desktop apps Classic Outlook for Windows is a desktop app included with Microsoft 365 Personal or Family subscriptions or non-subscription versions of Office such as Office Home & Business. New Outlook for Windows is available free on Windows devices or as a free download.If you don't already have new Outlook, you can download it from the Microsoft Store ...
Applies To: Outlook.com