Download and install or reinstall Microsoft 365 or Office 2021 on a PC ...
Change from a 32-bit version to a 64-bit version or vice versa. Activate Windows. Fix Bluetooth problems in Windows. Learn how to install, reinstall, or activate Microsoft 365 or Office 2019 on a PC or Mac.
Applies To:
Office 2021, Office 2021 for Mac, Office 2019, Office 2019 for Mac, Microsoft 365 for home, Office for business, Office 365 Small Business, Microsoft 365 admin, Office 365 operated by 21Vianet, Office 365 operated by 21Vianet - Admin, Microsoft 365 for Mac, Office 365 Germany - Enterprise, Office 365 Germany - Enterprise admin
Use the SUM function to sum numbers in a range - Microsoft Support
You can use a simple formula to sum numbers in a range (a group of cells), but the SUM function is easier to use when you’re working with more than a few numbers. For example =SUM (A2:A6) is less likely to have typing errors than =A2+A3+A4+A5+A6.
Applies To:
Excel for Microsoft 365, Excel for the web, Excel 2021, Excel 2019, Excel 2016
ファイル要求を作成する - Microsoft サポート
OneDriveまたは Sharepoint のファイル要求機能を使用すると、送信するリンクを使用して他のユーザーがファイルをアップロードできるフォルダーを選択できます。 ファイルを要求するPeopleは、ファイルのみをアップロードできます。 フォルダーの内容を表示したり、ファイルを編集、削除、またはダウンロードしたり、他のユーザーがファイルをアップロードしたかを確認することもできません。 ファイル要求の場合: ファイル要求リンクを持つすべてのユーザーがファイルを送信できます。 OneDriveする必要はありません。 送信されたすべてのファイルは、選択した 1 つのフォルダーに保存されます。 すべてのファイルには、アップロードしたユーザーを識別するのに役立つプレフィックスが付きます。
Applies To:
OneDrive for Business, SharePoint in Microsoft 365, OneDrive (work or school), OneDrive for Mac, OneDrive for Windows
Xbox Status | Xbox Support
Check the Xbox services, games, and apps for any service outages.
Where to enter your Office product key - Microsoft Support
If your purchase of Office or Microsoft 365 came with a product key, you enter your product key on one of the websites listed below for your product. After you enter your key, you can download and install Office, or you can renew your Microsoft 365 subscription. Tip: Get tech expertise with Business Assist.
Applies To:
Office 2021, Office 2021 for Mac, Office 2019, Office 2019 for Mac, Office 2016, Microsoft 365 for home, Office for business
VLOOKUP function - Microsoft Support
Learn how to use function VLOOKUP in Excel to find data in a table or range by row. Our step-by-step guide makes vlookup in excel easy and efficient.
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
Create a 3-D reference to the same cell range on multiple worksheets
A 3-D reference is useful and convenient way to reference several worksheets that follow the same pattern and cells on each worksheet contain the same type of data, such as when you consolidate budget data from different departments in your organization.
Applies To:
Excel for Microsoft 365, Excel 2021, Excel 2019, Excel 2016
Look up values with VLOOKUP, INDEX, or MATCH - Microsoft Support
The VLOOKUP and HLOOKUP functions, together with INDEX and MATCH, are some of the most useful functions in Excel. Note: The Lookup Wizard feature is no longer available in Excel. Here's an example of how to use VLOOKUP. =VLOOKUP (B2,C2:E7,3,TRUE) In this example, B2 is the first argument —an element of data that the function needs to work.
Applies To:
Excel for Microsoft 365, Excel for the web, Excel 2021, Excel 2019, Excel 2016
Request a refund for digital games | Xbox Support
If you pre-ordered a game and want to cancel, you can do so up to 10 days before the game launches at: Order history. After this time, you may be billed, and you’ll need to request a refund to cancel your order. For more info about digital game pre-orders, see: Pre-order Xbox digital games in the Microsoft Store.
Which version of Windows operating system am I running?
To find out which version of Windows your device is running, press the Windows logo key + R, type winver in the Open box, and then select OK. Here’s how to learn more: Select Start > Settings > System > About . Open About settings.