This article applies to Office Home & Business, Office Professional, and individually purchased Office apps. To switch an Office install to or from Microsoft 365, see Switch your Office license.. Change the product key for your version

Invisible digital signatures in Word, Excel, or PowerPoint. An invisible digital signature, like a visible digital signature line, assures the authenticity, integrity, and origin of a document.

Argument name. Description. Sum_range (required). The range of cells to sum. Criteria_range1 (required). The range that is tested using Criteria1.. Criteria_range1 and Criteria1 set up a search pair whereby a range is searched for specific criteria. Once items in the range are found, their corresponding values in Sum_range are added.. Criteria1 (required)

Notes: Meeting recordings won't capture whiteboards, annotations, shared notes or content shared in the stage view by apps, and also won't include videos or animations embedded in PowerPoint Live presentations.

Creating a passkey. To create a passkey for your Microsoft account, follow these steps on the device for which you’d like to create a passkey:

Troubleshooting: I don't see Automatic Replies. If you don't see Automatic Replies after selecting File, you're probably using a Gmail, Yahoo, or other POP or IMAP account that doesn't support the Outlook Automatic Replies feature.You can set up a rule that will reply to incoming messages—if you leave Outlook running while you're away.

Create contact lists. A contact list is a collection of email addresses, and is useful for sending email to a group of people. Contact lists are sometimes referred to as distribution lists.. For example, create a contact list named My book club and add all the members of your book club to it. When you want to send an email message to everyone in the club, just add My book club in the To line ...

使用 vlookup、hlookup 和其他函数（如 index 和 match）根据您输入的值搜索和查找数据。 本文将让您快速回顾 vlookup，然后链接到更多内容。

Repair programs in Control Panel. Select the Advanced options link under the name of the app (some apps don't have this option). On the page that opens, select Repair if it's available.If it isn't available or doesn't fix the problem, select Reset.

Note: If the file doesn't have UTF-8 encoding, the import tool may not recognize and display all text correctly.The import tool will then show you some example contacts from your file, and you can check that the text is readable and correct. If the text is not displayed correctly, select Cancel.You will need a file in UTF-8 encoding to continue.