If you've purchased Microsoft 365 Family, you can share your subscription benefits with up to five other people. For details, see Share your Microsoft 365 Family subscription.. Common questions about sharing

We would like to show you a description here but the site won’t allow us.

Microsoft Authenticator is a free app that helps you sign in to all your accounts without using a password - just use a fingerprint, face recognition, or a PIN.

If you want to track your Microsoft Rewards order after you redeem an award, sign in to the Rewards page with your Microsoft account, select Redeem and then select Order history.On the Order history page, find your order and then look under Status.. Open Rewards dashboard

To get support in Outlook.com, click here or select Help on the menu bar and enter your query. If the self-help doesn't solve your problem, scroll down to Still need help? and select Yes.. To contact us in Outlook.com, you'll need to sign in.

Collections in Microsoft Edge helps you keep track of your ideas on the web, whether you're shopping, planning a trip, collecting notes for research or lesson plans, or just want to pick up where you left off the last time you were browsing the internet.

Automatically fill a series of data in your worksheet, like dates, numbers, text, and formulas. Use the AutoComplete feature, Auto Fill Options button and more.

You can use the Advanced Filter dialog box to extract the unique values from a column of data and paste them to a new location. Then you can use the ROWS function to count the number of items in the new range.. Select the range of cells, or make sure the active cell is in a table. Make sure the range of cells has a column heading.

The SUMPRODUCT function returns the sum of the products of corresponding ranges or arrays.The default operation is multiplication, but addition, subtraction, and division are also possible. In this example, we'll use SUMPRODUCT to return the total sales for a given item and size:

注意: 数据将从所有列中删除，即使未在此步骤中选择所有列。例如，如果选择 Column1 和 Column2，但不选择 Column3，则用于查找重复项的“键”是两列 1 & Column2 的值。 如果在这些列中找到了重复项，则将删除整个行，包括表或区域中的其他列。