Open and use a shared mailbox in Outlook Web App
Type the email address of the other mailbox that you want to open and then select Open.Or, start typing and then select Search contacts and directory to find the mailbox you want to open. Select the shared mailbox you want to open, and then select Open.Another Outlook Web App session opens in a separate window, allowing access to the other mailbox.
Applies To: Outlook Web App
How to correct a #SPILL! error - Microsoft Support
Approach. Formula. 1. Reference just the lookup values you are interested in. This style of formula will return a dynamic array, but does not work with Excel tables. =VLOOKUP(A2:A7,A:C,2,FALSE)2. Reference just the value on the same row, and then copy the formula down.
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2019 for Mac, Excel 2016, Excel for iPad, Excel Web App, Excel for iPhone, Excel for Android tablets, Excel for Android phones
Perform an offline system update | Xbox Support
Click Save to save the console update.zip file to your computer.; Unzip the file by right-clicking on the file and selecting Extract all from the pop-up menu.
Record a meeting in Microsoft Teams - Microsoft Support
Notes: Meeting recordings won't capture whiteboards, annotations, shared notes or content shared in the stage view by apps, and also won't include videos or animations embedded in PowerPoint Live presentations.
Applies To: Microsoft Teams
Calibrate your HDR display using the Windows HDR Calibration app
Note: If you have a built-in display that can play streaming HDR video, but doesn’t support HDR games and apps, use Display calibration for HDR video found in Settings > System > Display > HDR.. To check if your display supports HDR games and apps, under Display capabilities on the HDR settings screen, see if the selected display says Use HDR is Supported or Not supported.
Contact - Microsoft Support
Contact Microsoft Support. What's new. Surface Pro; Surface Laptop; Surface Laptop Studio 2
Create or run a macro - Microsoft Support
To save time on tasks you do often, bundle the steps into a macro. First, you record the macro. Then you can run the macro by clicking a button on the Quick Access Toolbar or pressing a combination of keys.
Applies To: Word for Microsoft 365, Word for the web, Word 2021, Word 2019, Word 2016
SUMIFS function - Microsoft Support
Problem. Description. 0 (Zero) is shown instead of the expected result. Make sure Criteria1,2 are in quotation marks if you are testing for text values, like a person's name.. The result is incorrect when Sum_range has TRUE or FALSE values.. TRUE and FALSE values for Sum_range are evaluated differently, which may cause unexpected results when they're added. ...
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2019 for Mac, Excel 2016, Excel Web App
Change the email address or phone number for your Microsoft account
Warning When removing an email alias that’s connected to a Microsoft domain (such as @Outlook.com, @Live.com, or @Hotmail.com), that email is completely deleted from our systems and can’t be used to send or receive emails. It won’t be available for use again as an alias on another account. Microsoft doesn’t recycle email addresses, so it can’t be reclaimed at a future time.
Stay up to date with news and interests - Microsoft Support
The taskbar can display the temperature in Celsius (°C) or Fahrenheit (°F). To switch between these two units, select the weather icon on the taskbar, select the Edit location and unit icon on the weather card, select Celsius or Fahrenheit on the weather, and select Save. News and interests is supported in any taskbar orientation.