FILTER function - Microsoft Support
The FILTER function allows you to filter a range of data based on criteria you define.
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
Copy the window or screen contents - Microsoft Support
Capture screen shots to use in your documents. For more details and instructions, see Use Snipping Tool to capture screenshots.. Use the PRINT SCREEN key. Pressing PRINT SCREEN captures an image of your entire screen and copies it to the Clipboard in your computer's memory.
Applies To: Excel for Microsoft 365, Word for Microsoft 365, Outlook for Microsoft 365, PowerPoint for Microsoft 365, Access for Microsoft 365, Project Online Desktop Client, Publisher for Microsoft 365, Excel 2021, Word 2021, Outlook 2021, PowerPoint 2021, Access 2021, Project Professional 2021, Project Standard 2021, Publisher 2021, Visio Professional 2021, OneNote 2021, Excel 2019, Word 2019, Outlook 2019, PowerPoint 2019, Access 2019, Project Professional 2019, Project Standard 2019, Publisher 2019, Visio Professional 2019, Excel 2016, Word 2016, Outlook 2016, PowerPoint 2016, Access 2016, OneNote 2016, Project Professional 2016, Project Standard 2016, Publisher 2016, Visio Professional 2016, SharePoint Designer 2007
Stay protected with Windows Security - Microsoft Support
Tip: If you're a Microsoft 365 Family or Personal subscriber you get Microsoft Defender, our advanced security software for Windows, Mac, iOS, and Android, as part of your subscription.Learn more at Getting started with Microsoft Defender.
Break a link to an external reference in Excel - Microsoft Support
When you break a link to the source workbook of an external reference, all formulas that use the value in the source workbook are converted to their current values. Because this action cannot be undone, you may want to save a version of the destination workbook as a backup.
Applies To: Excel for Microsoft 365, Excel 2021, Excel 2019, Excel 2016, Excel 2013
Copy and paste specific cell contents - Microsoft Support
You can copy and paste specific cell contents or attributes (such as formulas, formats, comments, and validation). By default, if you use the Copy and Paste icons (or + C and + V), all attributes are copied. To pick a specific paste option, you can either use a Paste menu option or select Paste Special, and pick an option from the Paste Special box. . Attributes other than what you select are ...
Applies To: Excel for Microsoft 365 for Mac, Excel 2021 for Mac, Excel 2019 for Mac
Set up an authenticator app as a two-step verification method
Note: If you receive a prompt asking whether to allow the app to access your camera (iOS) or to allow the app to take pictures and record video (Android). select Allow so the authenticator app can access your camera to take a picture of the QR code in the next step.If you don't allow the camera, you can still set up the authenticator app as described in Manually add an account to the app.
SUMIFS function - Microsoft Support
Problem. Description. 0 (Zero) is shown instead of the expected result. Make sure Criteria1,2 are in quotation marks if you are testing for text values, like a person's name.. The result is incorrect when Sum_range has TRUE or FALSE values.. TRUE and FALSE values for Sum_range are evaluated differently, which may cause unexpected results when they're added. ...
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, Excel Web App
在 Windows 中卸载或删除应用和程序 - Microsoft 支持
可通过不同的方式删除应用和程序,因此如果找不到要查找的应用和程序,可以尝试另一个位置。 请注意,某些应用和程序内置于 Windows 中,无法卸载。
Allow messages to be sent on your behalf when sharing a folder or ...
Under Delegate Permissions, set these five options to None: Calendar, Tasks, Inbox, Contacts, and Notes.. Selecting None for each of these options gives the delegate the basic ability to send messages on your behalf, but nothing more. Grant the delegate additional permissions (such as the ability to see your inbox) by selecting Inbox, and from the dropdown select Reviewer, Author, or Editor.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016, Office for business, Office 365 Small Business, Microsoft 365 admin, Outlook on the web, New Outlook for Windows
Sign out of Office - Microsoft Support
Note: If you're using Microsoft 365, you should stay signed in so that Office stays activated.If you sign out, Office will prompt you to sign back in. To learn more, see What happens when you sign out of Office.
Applies To: Microsoft 365 for home