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.
在 Excel 中将 IF 与 AND、OR 和 NOT 函数配合使用 - Microsoft 支持
但如果需要测试多个条件,例如我们假设所有条件都需要为 True 或 False (AND),或只有一个条件需要为 True 或 False (OR),或者如果想要检查某个条件是否不 (NOT) 符合你的条件,这时该怎么做呢?这三个函数均可以单独使用,但它们更常见于与 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
取得 Excel 的 Office 增益集 - Microsoft 支援服務
按兩下載宏以閱讀更多相關資訊,包括較長的描述和客戶評論,如果有的話。 然後,按兩下 [新增]、[ 試用] 或 [ 購買] 以取得您想要的載入宏。. 如果系統提示您登入,請輸入您用來登入 Office 程式的電子郵件地址和密碼。
Applies To: Excel for Microsoft 365, Excel 2021, Excel 2019, Excel 2016
Create a treemap chart in Office - Microsoft Support
A treemap chart provides a hierarchical view of your data and makes it easy to spot patterns, such as which items are a store's best sellers. The tree branches are represented by rectangles and each sub-branch is shown as a smaller rectangle.
Applies To: Excel for Microsoft 365, Word for Microsoft 365, Outlook for Microsoft 365, PowerPoint for Microsoft 365, Excel for Microsoft 365 for Mac, Word for Microsoft 365 for Mac, Outlook for Microsoft 365 for Mac, PowerPoint for Microsoft 365 for Mac, Excel 2021, Word 2021, Outlook 2021, PowerPoint 2021, Excel 2021 for Mac, Word 2021 for Mac, Outlook 2021 for Mac, PowerPoint 2021 for Mac, Excel 2019, Word 2019, Outlook 2019, PowerPoint 2019, Excel 2019 for Mac, Word 2019 for Mac, Outlook 2019 for Mac, PowerPoint 2019 for Mac, Excel 2016, Word 2016, Outlook 2016, PowerPoint 2016, Excel for iPad, Excel for iPhone
Create workbook links - Microsoft Support
Important: Workbook links are considered potentially unsafe and must be enabled when you open a formula workbook.When you open a formula workbook, click Enable Content in the Message Bar to allow the workbook links to function. If you don't, Excel keeps the most recent values and disables refreshing the links with values from the data workbook.
Applies To: Excel for Microsoft 365, Excel for the web, Excel 2021, Excel 2019, Excel 2016
Filter junk email and spam in Outlook - Microsoft Support
When you mark email as junk, you can report the message to Microsoft to help improve the accuracy of the junk email filter. To set junk email reporting options, select Settings > Mail > Automatic processing > Junk email reporting.. Specify when to send junk email reports
Applies To: Office for business, Office 365 Small Business, New Outlook for Windows, Outlook on the web for Exchange Server 2016, Outlook on the web for Exchange Server 2019
Change privacy settings in Windows - Microsoft Support
Explore subscription benefits, browse training courses, learn how to secure your device, and more.
Open and use a shared mailbox in Outlook Web App
Type the email address of the other mailbox that you want to open and then select Open.Or, start typing and then select Search contacts and directory to find the mailbox you want to open. Select the shared mailbox you want to open, and then select Open.Another Outlook Web App session opens in a separate window, allowing access to the other mailbox.
Applies To: Outlook Web App
插入或删除行和列 - Microsoft 支持
格式设置选项. 选择应用了格式设置的行或列时,该格式设置将被传输到插入的新行或列。 如果不希望应用格式设置,可以在插入后选择“插入选项”按钮,然后从以下选项中进行选择: 如果“插入选项”按钮不可见,请转到“剪切、复制和粘贴”组中的“文件”>”选项”>”高级”,选中“显示 ...
Applies To: Excel for Microsoft 365, Excel for the web, Excel 2021, Excel 2019, Excel 2016
Change an email signature - Microsoft Support
Whether it’s a new job title (congratulations!) or a phone number change, make sure you keep your email message signature up-to-date. If you're using new Outlook, for more information about email signatures, or if you haven’t created one yet, see Add a signature to messages.. Select File > Options > Mail > Signatures.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016
Insert comments and notes in Excel - Microsoft Support
If you need to edit the note, right-click the cell, and then click Edit Comment.If you're using Excel for Office 365, right-click the cell and choose Edit Note.. If you need to delete the note, right-click the cell and choose Delete Comment.If you're using Excel for Office 365, right-click the cell and choose Delete Note.
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 2013, Excel for iPad, Excel for iPhone, Excel for Android tablets, Excel for Android phones, Excel Mobile