Create a simple formula in Excel - Microsoft Support
You can create a simple formula to add, subtract, multiply or divide values in your worksheet. Simple formulas always start with an equal sign (=), followed by constants that are numeric values and calculation operators such as plus (+), minus (-), asterisk (*), or forward slash (/) signs.The following is an example of a simple formula.
Applies To:
Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2019 for Mac, Excel 2016
修复 Office 应用程序 - Microsoft 支持
Microsoft 365 专属 Excel Microsoft 365 专属 Word Microsoft 365 专属 Outlook Microsoft 365 专属 PowerPoint Microsoft 365 专属 Access OneNote for Microsoft 365 Microsoft 365 专属 Publisher Visio 计划 2 Excel 2021 Word 2021 Outlook 2021 PowerPoint 2021 Access 2021 Project 专业版 2021 Project Standard 2021 Publisher 2021 Visio Professional 2021 Visio Standard 2021 Office 2021 ...
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, Publisher for Microsoft 365, Visio Plan 2, Excel 2021, Word 2021, Outlook 2021, PowerPoint 2021, Access 2021, Project Professional 2021, Project Standard 2021, Publisher 2021, Visio Professional 2021, Visio Standard 2021, Office 2021, OneNote 2021, Excel 2019, Word 2019, Outlook 2019, PowerPoint 2019, Access 2019, Project Professional 2019, Project Standard 2019, Publisher 2019, Visio Professional 2019, Visio Standard 2019, Office 2019, 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, Office 2016, Microsoft 365 for home, Office for business, Office 365 Small Business, Microsoft 365 admin, Office 365 operated by 21Vianet, Office 365 operated by 21Vianet - Small Business Admin, Office 365 operated by 21Vianet - Admin, InfoPath 2013, Office 365 Germany - Enterprise, Office 365 Germany - Enterprise admin
清除所有文本格式 - Microsoft 支持
在 Word 和发布服务器中. 在“开始”选项卡上的“字体”组中，单击“清除所有格式”。 在 PowerPoint 中. 在“开始”选项卡上的“字体”组中，单击“清除所有格式”。 在 Outlook 中. 在“邮件”选项卡上的“基本文本”组中，单击“清除所有格式”。 OneNote. 在“ 开始 ”选项卡上的“ 基本文本 ”组 ...
Applies To:
Word for Microsoft 365, Outlook for Microsoft 365, PowerPoint for Microsoft 365, OneNote for Microsoft 365, Publisher for Microsoft 365, Word for Microsoft 365 for Mac, PowerPoint for Microsoft 365 for Mac, Word for the web, PowerPoint for the web, Word 2021, Outlook 2021, PowerPoint 2021, Publisher 2021, OneNote 2021, Word 2019, Outlook 2019, PowerPoint 2019, Publisher 2019, Word 2019 for Mac, PowerPoint 2019 for Mac, Word 2016, Outlook 2016, PowerPoint 2016, OneNote 2016, Publisher 2016
显示或隐藏零值 - Microsoft 支持
通过使用“高级”选项卡中的选项，或者使用数字格式、条件格式、函数以及在数据透视表中隐藏零值的方式，可以在 Excel 工作表中隐藏或显示零值。
Applies To:
Excel for Microsoft 365, Excel 2021, Excel 2019, Excel 2016
使用实时字幕更好地了解音频 - Microsoft 支持
选择 “屏幕上方”、“ 屏幕下方”或“ 屏幕上叠加”。. 选择 “屏幕上方”或“ 屏幕下方”时，字幕窗口将显示为停靠在桌面上预留空间中的顶部或底部屏幕边缘，并且字幕窗口不会阻止其他应用。当停靠到顶部时，你可能会发现实时字幕在虚拟会议或对话中共享视频时效果良好，而在其他情况 ...
Switch to the new Microsoft Teams - Microsoft Support
When in the new Teams, turn on (or off) notifications by selecting Settings and more at the top of the new Teams, then selecting Settings > Notifications > Open Windows notifications settings.Find Microsoft Teams (work preview) in the apps list and set your preference.
Applies To:
Microsoft Teams
Microsoft 365 Training
Get productive quickly with Microsoft 365 videos and tutorials. Explore Microsoft 365 training guides and tips to collaborate with anyone, anywhere.
Add an app to run automatically at startup in Windows 10
Right-click the app, select More, and then select Open file location.This opens the location where the shortcut to the app is saved. If there isn't an option for Open file location, it means the app can't run at startup.
Convert numbers stored as text to numbers - Microsoft Support
Most of the time, Excel will recognize this, and you'll see an alert next to the cell where numbers are being stored as text. If you see the alert:
Applies To:
Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2019 for Mac, Excel 2016, Excel Web App
Examples of common formulas in lists - Microsoft Support
Note: Calculated fields can only operate on their own row, so you can't reference a value in another row, or columns contained in another list or library.Lookup fields are not supported in a formula, and the ID of newly inserted row can't be used as the ID doesn't exist when the formula is processed.
Applies To:
SharePoint Server Subscription Edition, SharePoint Server 2019, SharePoint Server 2016, SharePoint Server 2013 Enterprise, SharePoint Server Central Admin 2013, SharePoint in Microsoft 365, SharePoint Server 2010, Microsoft Lists, SharePoint in Microsoft 365 Small Business