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

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.

For the website(s) you would like to allow scripting, enter the address within the Add this website to the zone text box and click Add. Note: If the address does not begin with "https:", you many need to uncheck "Require server verification (https:) for all sites in this zone".

Microsoft Authenticator is a free app that helps you sign in to all your accounts without using a password - just use a fingerprint, face recognition, or a PIN.

If you want to track your Microsoft Rewards order after you redeem an award, sign in to the Rewards page with your Microsoft account, select Redeem and then select Order history.On the Order history page, find your order and then look under Status.. Open Rewards dashboard

The slide show opens in the Recording window (which looks similar to Presenter view), with buttons at the top left for starting, pausing, and stopping the recording.Click the round, red button (or press R on your keyboard) when you are ready to start the recording. A three-second countdown ensues, then the recording begins.

Most of the time, Excel will recognize this, and you'll see an alert next to the cell where numbers are being stored as text. If you see the alert:

A family group is a set of individuals connected through the Microsoft Family Safety app on their Windows, Xbox, or mobile devices. Establishing a family group is an easy, effective way to encourage healthy online habits and manage busy schedules.

Tip Sometimes the Load To command is dimmed or disabled. This can occur the first time you create a query in a workbook. If this occurs, select Close & Load, in the new worksheet, select Data > Queries & Connections > Queries tab, right click the query, and then select Load To.Alternatively, on the Power Query Editor ribbon select Query > Load To. ...

In Outlook, you have the option to: Snooze or dismiss events or tasks | Turn the notifications on or off | Add reminders to events | Add reminders to tasks | Troubleshoot notifications. Snooze or dismiss an event or task. With the reminders window, you can select to snooze calendar events and tasks, join a Teams meeting, or dismiss events and tasks.