SUMIF function - Microsoft Support
sum_range Optional.The actual cells to add, if you want to add cells other than those specified in the range argument. If the sum_range argument is omitted, Excel adds the cells that are specified in the range argument (the same cells to which the criteria is applied).. Sum_range should be the same size and shape as range.If it isn't, performance may suffer, and the formula will sum a range of ...
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
Troubleshoot installing Office - Microsoft Support
The issues you encounter when trying to install Microsoft 365, or Office 2021, 2019, or 2016 and how you fix them depends on whether your product is part of an Office for home or Office for business plan.. In addition, with Office for business plans only admins responsible for managing Microsoft 365 in their organization can do certain tasks. Therefore, admins should view the issues and ...
Applies To: Office 2021, Office 2021 for Mac, Office 2019, Office 2019 for Mac, Office 2016, Microsoft 365 for home, Office for business, Office 365 Small Business, Microsoft 365 admin, Microsoft 365 for Mac
Stay safe with a genuine Office license - Microsoft Support
Learn how to tell if your Office software is genuine. To help determine if your Microsoft software is genuine, go to our How to Tell site for more information. Here you'll learn about authentic packaging, including what to look for with product key labels, and Certificate of Authenticity (COA), how to report counterfeit software, and find out what your shopping and licensing options are.
Applies To: Office 2019
Clipboard in Windows - Microsoft Support
Learn how to use the cloud-based clipboard in Windows, share clipboard items across your devices, and pin items to your clipboard menu.
更改或删除单个页面上的页眉或页脚 - Microsoft 支持
重要: 分节符不同于分页符。如果想要更改页眉或页脚的页面之前已有分页符, 请删除分页符 并将其替换为分节符,如下所示。
Applies To: Word for Microsoft 365, Word for Microsoft 365 for Mac, Word for the web, Word 2021, Word 2021 for Mac, Word 2019, Word 2019 for Mac, Word 2016
Server settings you'll need from your email provider
Setting. Description. Write Your Setting Here. Example. Host Name. Your incoming mail server name. outlook.office365.com. Username. The email address you want to set up.
Applies To: Outlook for Microsoft 365, Outlook for Microsoft 365 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 - Small Business Admin, Outlook.com, Office 365 operated by 21Vianet - Admin, New Outlook for Windows, Outlook for iOS, Outlook for Windows Phone 10, Outlook Mail for Windows 10, Outlook on the web for Exchange Server 2016
Reset OneDrive - Microsoft Support
This means your files won’t be downloaded again if they haven’t changed. If you had chosen to sync only some folders before the reset, you will need to do that again once sync has completed. Read Choose which OneDrive folders to sync to your computer for more information.
Applies To: OneDrive for Business, SharePoint Server Subscription Edition, SharePoint Server 2019, SharePoint in Microsoft 365, OneDrive (work or school), OneDrive (home or personal), OneDrive (work or school) operated by 21Vianet, OneDrive for Mac, OneDrive for Windows
Insert a table of contents - Microsoft Support
Note: If you use a Manual Table of Contents style, Word won't use your headings to create a table of contents and won't be able to update it automatically. Instead, Word will use placeholder text to create the look of a table of contents so you can manually type each entry into the table of contents.
Applies To: Word for Microsoft 365, Word for Microsoft 365 for Mac, Word for the web, Word 2021, Word 2021 for Mac, Word 2019, Word 2019 for Mac, Word 2016
Use add-ins in Outlook - Microsoft Support
Notes: Starting in Outlook for Windows Version 2303 (Build 16215.10000), the All Apps button replaces the Get Add-ins buttonon the ribbon to view installed add-ins and access the Office Store.If you’re using an earlier version of Outlook, you'll see the Get Add-ins button instead.. If you don't see All Apps on the ribbon, your administrator may have turned off add-ins for your organization.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016, Outlook on the web, New Outlook for Windows, Outlook Web App
Edit photos and videos in Windows - Microsoft Support
Blur. Select the Blur option, then use the slider to adjust the Blur intensity, then select Apply to blur the background.. Remove. Select the Remove option, then select Apply to remove the image background.. Replace. Select the Replace option, then use the color palette to select the background color. Alternatively, you can specify the RGB values for the desired color.