Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.
SUBSTITUTE 函数 - Microsoft 支持
本文介绍 Microsoft Excel 中 SUBSTITUTE 函数的公式语法和用法。. 说明. 在文本字符串中用 new_text 替换 old_text。 如果需要在某一文本字符串中替换指定的文本,请使用函数 SUBSTITUTE;如果需要在某一文本字符串中替换特定位置处的任意文本,请使用函数 REPLACE。
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
Change your screen saver settings - Microsoft Support
Select the Start button, then go to Settings > Personalization > Lock screen, and select Screen saver settings.In the Screen Saver Settings window, choose a screen saver from the drop-down list. Change your screen saver settings
使用 SUM 函数对区域中的数字求和 - Microsoft 支持
可以使用 简单的公式对) 一组单元格 (区域中的数字求和,但在处理多个数字时 ,sum 函数 更易于使用。 例如,=sum (a2:a6) 出现键入错误的可能性小于 =a2+a3+a4+a5+a6。 下面是使用两个单元格区域的公式: =sum (a2:a4,c2:c3) 对区域 a2:a4 和 c2:c3 中的数字求和。 可按 enter 获取总计 39787。
Applies To: Excel for Microsoft 365, Excel for the web, Excel 2021, Excel 2019, Excel 2016
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
在公式中包含文本 - Microsoft 支持
我们经常听到你希望通过在公式中包含文本(例如“已售出 2,347 个单位”)来使数据更易于理解。 若要在函数和公式中包含文本,请将文本括在双引号 (“”) 。
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 中添加水印 - Microsoft 支持
向 Excel 工作表添加“草稿”、“机密”等水印或你自己的设计(如公司徽标)
Applies To: Excel for Microsoft 365, Excel for the web, Excel 2021, Excel 2019, Excel 2016, Excel 2013
How do I log on as an administrator? - Microsoft Support
Open User Accounts by clicking the Start button , clicking Control Panel, clicking User Accounts and Family Safety, clicking User Accounts, and then clicking Manage another account .. If you're prompted for an administrator password or confirmation, type the password or provide confirmation.
Using your keyboard - Microsoft Support
The following illustration shows how these keys are arranged on a typical keyboard. Your keyboard layout might be different. Typing text. Whenever you need to type something in a program, e‑mail message, or text box, you'll see a blinking vertical line ( ) called the cursor or insertion point.It shows where the text that you type will begin.
手动将帐户添加到Microsoft Authenticator应用 - Microsoft 支持
注意. 有关双重验证和 Facebook 帐户的详细信息,请参阅什么是双重身份验证及其工作原理? 添加 Amazon 帐户. 可以通过启用双重验证,然后将帐户添加到应用来添加 Amazon 帐户。
IF 函数 - 嵌套公式和避免错误 - Microsoft 支持
因此 IF 语句可能有两个结果。 第一个结果是比较结果为 True,第二个结果是比较结果为 False。 IF 语句非常强大,其构成了许多电子表格模型的基础,但也是导致许多电子表格问题的根本原因。
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