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 ...

If you forgot your PIN and need to reset it, you can do so from the Windows sign-in screen. Look below the PIN text box: If you see I forgot my PIN , select it and follow the instructions to reset your PIN.If there are multiple accounts on the device, choose the one you need to reset.

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 ...

The spelling and grammar checker isn't working as expected. Add words to your spell check dictionary. The spelling or grammar checker isn't checking words in a different language correctly. Choose AutoCorrect options for capitalization, spelling, and symbols. Check spelling before sending a message in Outlook

Use a macro to extract data from a corrupted workbook If a chart is linked to the corrupted workbook, try using a macro to extract the source data of the chart.. Copy the following macro code and paste it in a module sheet: Sub GetChartValues() Dim NumberOfRows As Integer

Things to try first. Try these things first to help you fix or narrow down the connection problem. Run Get Help to troubleshoot and fix common connection problems. Right click the network icon in the right side of the taskbar and select Diagnose network problems or open Get Help for Network & Internet

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.

If you can't sign into your Microsoft account, most issues can be identified by our sign-in helper tool. The tool will ask you to enter the email address or mobile phone number you're trying to sign in with and check the details you provide. If we detect a problem with your account, we'll tell you what you need to do to solve the problem.

If you can't open Microsoft Edge, or if it opens briefly and then closes, or if you’re unable to open specific webpages, here are some things you can try. Close other tabs, extensions, and apps. Your computer may have run out of memory, and can't load the site while also running your apps, extensions, and programs.

If you're unable to open and view the notebook in OneNote for the web, the source of the sync problem is likely with your server. If your notebook is stored on OneDrive, check our Service Status page for any known interruptions or outages. If your notebook is stored on SharePoint, you'll need to contact your administrator to report and troubleshoot the problem.