SUMIFS function - Microsoft Support
Problem. Description. 0 (Zero) is shown instead of the expected result. Make sure Criteria1,2 are in quotation marks if you are testing for text values, like a person's name.. The result is incorrect when Sum_range has TRUE or FALSE values.. TRUE and FALSE values for Sum_range are evaluated differently, which may cause unexpected results when they're added. ...
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
Fix problems detaching or attaching your Surface Book keyboard
Both batteries in the Surface Book must be charged above 10 percent to detach the keyboard. If either of the batteries has less than a 10 percent charge, the green light on the Detach key won’t come on when you press it and you won’t be able to detach the keyboard.
Uninstall Office from a PC - Microsoft Support
Tip: If you installed the Microsoft 365 apps as part of a suite, such as Office Home and Student or Microsoft 365, search for the suite name.For stand-alone apps search by the app name, such as Project or Visio. In most cases you can't uninstall an individual app if it's included in your Microsoft 365 suite.
Applies To: Office 2021, Office 2019, Office 2016, 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, Office 365 operated by 21Vianet - Admin, Office 365 Germany - Enterprise, Office 365 Germany - Enterprise admin
Remove a page break - Microsoft Support
How to remove manual page breaks in Word, and adjust where automatic page breaks occur in your documents.
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
View and delete browser history in Microsoft Edge
Types of info. What will be deleted. Where it's stored. Browsing history. The URLs of sites you've visited, and the dates and times of each visit. On your device (or, if sync is turned on, across your synced devices)
Microsoft Family group roles, permissions, and data sharing
Family members. Family members are all ages and can share important information with organizers, such as their locations or screen time. They can also request purchase approvals or ask for more time on their devices easily through their Family Safety app.
Create forms that users complete or print in Excel
You can create a form in Excel by adding content controls, such as buttons, check boxes, list boxes, and combo boxes to a workbook. Other people can use Excel to fill out the form and then print it if they choose to.
Applies To: Excel for Microsoft 365 for Mac, Excel 2021 for Mac, Excel 2019 for Mac
Check spelling and grammar in Office - Microsoft Support
To. Do this. Change the word. Under Suggestions, click the word that you want to use, and then click Change.. Change every occurrence of this word in this document. Under Suggestions, click the word that you want to use, and then click Change All.. Ignore this word and move on to the next misspelled word
Applies To: Excel for Microsoft 365, Word for Microsoft 365, Outlook for Microsoft 365, PowerPoint for Microsoft 365, Project Online Desktop Client, Publisher for Microsoft 365, Excel 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, Project Professional 2021, Project Standard 2021, Publisher 2021, Visio Professional 2021, Visio Standard 2021, OneNote 2021, Excel 2021 for Mac, Outlook 2021 for Mac, PowerPoint 2021 for Mac, Excel 2019, Word 2019, Outlook 2019, PowerPoint 2019, Project Professional 2019, Project Standard 2019, Publisher 2019, Visio Professional 2019, Visio Standard 2019, Excel 2019 for Mac, Outlook 2019 for Mac, PowerPoint 2019 for Mac, Excel 2016, Word 2016, Outlook 2016, PowerPoint 2016, OneNote 2016, Project Professional 2016, Project Standard 2016, Publisher 2016, Visio Professional 2016, Visio Standard 2016, InfoPath 2013, InfoPath Filler 2013
Microsoft Store & billing help
Get Microsoft billing support. Find help with Microsoft Store purchases, subscriptions, refunds, payment options, and checking your order history.
Tutorial: Import Data into Excel, and Create a Data Model
Note: Notice the checkbox at the bottom of the window that allows you to Add this data to the Data Model, shown in the following screen.A Data Model is created automatically when you import or work with two or more tables simultaneously. A Data Model integrates the tables, enabling extensive analysis using PivotTables, Power Pivot, and Power View.
Applies To: Excel for Microsoft 365, Excel 2021, Excel 2019, Excel 2016