In the following example we used the formula =FILTER(A5:D20,C5:C20=H2,"") to return all records for Apple, as selected in cell H2, and if there are no apples, return an empty string ("").

Whether it’s a new job title (congratulations!) or a phone number change, make sure you keep your email message signature up-to-date. If you're using new Outlook, for more information about email signatures, or if you haven’t created one yet, see Add a signature to messages.. Select File > Options > Mail > Signatures.

In the following countries, you have the right to cancel a subscription that has recurring billing with immediate effect and receive a prorated refund as described in the Microsoft Consumer Subscription Prorated Refund Policy:

If none of those options work, select the Start button > Settings > Accounts , then find the Microsoft account you used to sign in to the Xbox app and select Remove.Then go back to the Xbox app and sign in with the Microsoft account you just removed. Open Settings

Battery Life: Lowering your refresh rate can save battery power by reducing the amount of energy your display consumes.This can be useful when you are using a laptop or tablet and want to extend your battery life.

Training: Get up and running quick. Note: If you already had an account signed in to OneDrive and you want to add another account, click the OneDrive cloud icon up in the Menu bar, click the three dots to open the menu, and select Preferences.Click the Account tab, select Add an Account to start OneDrive Setup, and then sign in.

Tip: If you don’t like the name of the template (usually Book 1), click the name in the Excel for the web title bar at the top of the page and type a different name.

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

Going passwordless refers to removing your password and using a passwordless method to sign in instead. Passwordless solutions such as Windows Hello, the Microsoft Authenticator app, SMS or Email codes, and physical security keys provide a more secure and convenient sign-in method. While passwords can be guessed, stolen, or phished, only you can provide fingerprint authentication, or provide ...

Splits text strings by using column and row delimiters. The TEXTSPLIT function works the same as the Text-to-Columns wizard, but in formula form.It allows you to split across columns or down by rows.