Guidelines and examples of array formulas - Microsoft Support
An array formula (one that spans multiple cells) can do calculations on rows and columns of cells where you might otherwise need to use several formulas. For example, you can count the number of characters that are contained in a range of cells, sum only numbers that meet certain conditions (such as the lowest values in a range or numbers that fall between an upper and lower boundary), and sum ...
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2019 for Mac, Excel 2016, Excel for iPad, Excel for iPhone
Check grammar, spelling, and more in Word - Microsoft Support
Word marks spelling, grammar, and stylistic issues with an underline. Control-click the word or phrase and choose one of the options. If Word incorrectly underlined a word as misspelled and you want to add that word to your dictionary so that Word will properly recognize it in the future, see Add or edit words in a spell check dictionary. If spelling or grammatical errors aren't underlined ...
Applies To: Word for Microsoft 365, Word for Microsoft 365 for Mac, Word 2021, Word 2021 for Mac, Word 2019, Word 2019 for Mac, Word 2016
Create an ISO file for Windows 10 - Microsoft Support
Unlike in previous versions of Windows, you’ll need to use the media creation tool to create an ISO file to install Windows 10. Make sure you have a license to install Windows 10, and then follow these steps:
My microphone isn't working in Microsoft Teams
Use your phone's audio. If your mic doesn’t work after trying the solutions above and you see one of the messages below, select Call me back to use your phone’s mic.. Enter your phone number and select Call me to receive a call from Teams that will connect you to your meeting. Your audio will come from your phone, but other content sharing will still take place on your desktop.
Applies To: Microsoft Teams
Cancel a Microsoft 365 subscription - Microsoft Support
Notes: If you don't see an option to Cancel, but instead see a link that says Turn on recurring billing, this means your subscription is already set to expire on the date shown and you won't be automatically charged after this date. There's nothing further to do at this time, and you can continue to use the product until your Microsoft 365 subscription expires.
How to find and enable missing Copilot button in Microsoft 365 apps
Important: Copilot in Outlook only supports work or school accounts, and Microsoft accounts using outlook.com, hotmail.com, live.com, and msn.com email addresses at this time. Any Microsoft account using an account from a third-party email provider, such as a Gmail, Yahoo, or iCloud, can still use Outlook, but won't have access to the Copilot features in Outlook.
Applies To: Excel for Microsoft 365, Word for Microsoft 365, Outlook for Microsoft 365, PowerPoint for Microsoft 365, OneNote for Microsoft 365, Excel for Microsoft 365 for Mac, Word for Microsoft 365 for Mac, Outlook for Microsoft 365 for Mac, PowerPoint for Microsoft 365 for Mac, OneNote for Microsoft 365 for Mac
Fix File Explorer if it won't open or start - Microsoft Support
Learn how to troubleshoot File Explorer problems in Windows. To open File Explorer in Windows 10, select its icon on the taskbar, press the Windows logo key + E on your keyboard, or select Start > Documents (directly beneath your user icon).. Here are some things to try if File Explorer won't open.
Add an email account to Outlook for Windows - Microsoft Support
Outlook won't accept my password. If you've forgotten the password for a Microsoft account, user our sign-in helper to get back into your account.. If you know you’re using the correct password for your email account but Outlook won’t accept it, you might have an email account that requires additional security.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016, Microsoft 365 admin, New Outlook for Windows
Find and replace text - Microsoft Support
lo@t finds "lot" and "loot." The beginning of a word < <(inter) finds "interesting" and "intercept" but not "splintered." The end of a word > (in)> finds "in" and "within," but not "interesting." Word for the web lets you find and replace basic text. You can match case or fine whole words only. For more varied options, open your document in ...
Applies To: Word for Microsoft 365, Word for the web, Word 2021, Word 2019, Word 2016
A driver can't load on this device - Microsoft Support
Warning: Turning off Memory Integrity on a Secured-core PC takes the device out of a Secured-core state.If you choose to continue using your device without addressing the driver problem, you might discover that the functionality the driver supports does not work any longer, which could have consequences ranging from negligible to severe.