Note: If you have a current version of Microsoft 365, then you can input the formula in the top-left-cell of the output range, then press ENTER to confirm the formula as a dynamic array formula. Otherwise, the formula must be entered as a legacy array formula by first selecting the output range, input the formula in the top-left-cell of the output range, then press CTRL+SHIFT+ENTER to confirm it.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

When you mark email as junk, you can report the message to Microsoft to help improve the accuracy of the junk email filter. To set junk email reporting options, select Settings > Mail > Automatic processing > Junk email reporting.. Specify when to send junk email reports

Sign out of your account and then sign in to your new account. If everything is fixed, move your personal data and files to the new account. To move your personal files from your old account to your new account, try opening File Explorer, expanding This PC > OSDisk (C:), and looking in the Users folder, where you should see folders for both accounts.

To activate Windows 11 using an internet connection: As Windows 11 will automatically activate if you are connected to the internet, you can confirm your activation status by selecting Start > Settings > System > Activation and looking under Windows.. If online activation fails, first try the activation troubleshooting in Activate Windows.. To activate Windows 11 by phone:

Choose number of pages to print per sheet: Printing multiple pages on a single sheet of paper is a useful technique to save paper, reduce printing costs, and create compact versions of your documents. The number of pages that can be printed on a single sheet depends on the capabilities of your printer and the printing options you choose (Example: 1, 2, 4, 6, 9 or 16 pages per sheet).

Voice Recorder is an app for recording lectures, conversations, and other sounds (previously called Sound Recorder). Hit the big Record button (1), and Add a marker (3) to identify key moments as you record or play (2).Then you can Trim (5), Rename (7), or Share your recordings (4), which are saved in Documents > Sound recordings.Select the Delete icon (6) to delete your recording, or See more ...

Learn how to connect to a projector or to another PC in Windows using the keyboard shortcut "Windows logo key + P", the Connect app (for Windows 10), or the Wireless Display app (for Windows 11).

Tip: If you're a Microsoft 365 Family or Personal subscriber you get Microsoft Defender, our advanced security software for Windows, Mac, iOS, and Android, as part of your subscription.Learn more at Getting started with Microsoft Defender.

Download Windows Media Player. Get Windows Media Player for your version of Windows, or learn how to play Windows Media files on your Mac. Get the details here.