Lock or unlock specific areas of a protected worksheet
Clear this check box. To prevent users from. Select locked cells. Moving the pointer to cells for which the Locked check box is selected on the Protection tab of the Format Cells dialog box. By default, users are allowed to select locked cells.
Applies To: Excel for Microsoft 365, Excel 2021, Excel 2019, Excel 2016
Set up the Microsoft Authenticator app as your verification method
Method. Used for. Authenticator app. Two-factor verification and password reset authentication. Text messages. Two-factor verification and password reset authentication.
使用@mentions在 Outlook for Windows 中引起某人的注意 - Microsoft 支持
若要在电子邮件或会议邀请中吸引某人的注意,请在邮件或邀请中键入 @ 符号,后跟其姓名。 这样做将突出显示其姓名,并提示 Outlook 将其添加到“To”行,确保他们注意到,并在收件箱的邮件旁边添加 @ 符号。
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, New Outlook for Windows
Chat with others in Microsoft Teams - Microsoft Support
Use Microsoft Teams to chat online with the people you interact with. Start all chats the same way: by selecting New chat at the top of your chat list.. Start a chat with another person
Applies To: Microsoft Teams
COUNTIFS 函数 - Microsoft 支持
备注. 每个区域的条件一次应用于一个单元格。 如果所有的第一个单元格都满足其关联条件,则计数增加 1。 如果所有的第二个单元格都满足其关联条件,则计数再增加 1,依此类推,直到计算完所有单元格。
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
向 Outlook for Mac 添加电子邮件帐户 - Microsoft 支持
可通过几个快速步骤在 Outlook for Mac 中设置大多数电子邮件帐户(包括 Microsoft 365、Exchange Server 帐户、Outlook.com、Hotmail.com、Live.com 和 Google 帐户)。
Applies To: Outlook for Microsoft 365 for Mac
Troubleshooting verification code issues - Microsoft Support
That verification method isn’t working right now: Sometimes the block may be tied to the verification method you are using.Try using another verification method connected to your account. For example, if you are using SMS to verify yourself and are hitting a block, try using an alternate email that is connected to the account to receive your authorization code.
Applies To: Microsoft account dashboard
复制并粘贴特定单元格的内容 - Microsoft 支持
可以复制并粘贴特定单元格内容或属性 (,例如公式、格式、注释和验证) 。 默认情况下, 如果使用复制 和 粘贴 图标 (或 + c 和 + v) ,则会复制所有属性。 若要选择特定粘贴选项,可以使用“粘贴”菜单选项,或选择“选择性粘贴”,然后从“选择性粘贴”框中选择选项。
Applies To: Excel for Microsoft 365 for Mac, Excel 2021 for Mac, Excel 2019 for Mac
IF function – nested formulas and avoiding pitfalls
Multiple IF functions can be nested together to allow for multiple criteria. The Excel IF function statement allows you to make a logical comparison between a value and what you expect by testing for a condition and returning a result if True or False.
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, Excel for Windows Phone 10
输入公式 - Microsoft 支持
提示. 在单元格中输入公式时,该公式也会在编辑栏中显示。 使用编辑栏中的快捷方式帮助创建公式: 选择 检查公式。 如果没有错误,则该单元格将显示公式的结果。
Applies To: Excel for Microsoft 365 for Mac, Excel 2021 for Mac, Excel 2019 for Mac