Dynamic array formulas and spilled array behavior - Microsoft Support
Legacy array formulas entered via CTRL+SHIFT+ENTER (CSE) are still supported for back compatibility reasons, but should no longer be used. If you like, you can convert legacy array formulas to dynamic array formulas by locating the first cell in the array range, copy the text of the formula, delete the entire range of the legacy array, and then re-enter the formula in the top left cell.
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 2016, Excel for iPad, Excel for iPhone, Excel for Android tablets, Excel for Android phones
KB5034441: Windows Recovery Environment update for Windows 10, version ...
IMPORTANT This update is not needed and will not be offered if your Windows Recovery Environment (WinRE) meets any of the following conditions: If the WinRE recovery partition does not have sufficient free space.
Set up email in the Outlook for Android app - Microsoft Support
If you're having trouble using the Outlook for Android mobile app, Open an in-app Outlook support ticket. If you have a work or school account that uses Microsoft 365 for business or Exchange-based accounts, there may be additional requirements set by your IT admin.
Applies To: Outlook for Microsoft 365, Outlook for Microsoft 365 for Mac, Outlook 2021, Outlook 2021 for Mac, Outlook 2019, Outlook 2019 for Mac, Outlook 2016, Microsoft 365 for home, Office for business, Office 365 Small Business, Microsoft 365 admin, Outlook.com, New Outlook for Windows
Fix problems connecting your Google account to the Microsoft Cloud
If you're having trouble connecting your Gmail account to Outlook or Mail for Windows 10, this might be due to your Gmail settings. Follow the steps below to change your Gmail settings and fix the issue.
Applies To: Outlook for Microsoft 365, Outlook for Microsoft 365 for Mac, Outlook 2021, Outlook 2021 for Mac, Outlook 2019, Outlook 2019 for Mac, Outlook 2016, Outlook.com, Calendar for Windows 10, Mail for Windows 10, Outlook on the web for Exchange Server 2016
October 10, 2023—KB5031358 (OS Build 22000.2538)
Windows 11, version 23H2 ; July 25, 2024—KB5040527 (OS Builds 22621.3958 and 22631.3958) Preview; July 9, 2024—KB5040442 (OS Builds 22621.3880 and 22631.3880)
Record a meeting in Microsoft Teams - Microsoft Support
Learn how to record Teams meeting. Capture audio, video, screen sharing activity, and troubleshoot recordings in Microsoft Teams.
Applies To: Microsoft Teams
Create a new workbook - Microsoft Support
A workbook is a file that contains one or more worksheets to help you organize data. You can create a new workbook from a blank workbook or a template. By default, a new workbook contains three worksheets, but you can change the number of worksheets that you want a new workbook to contain. You can also add and remove worksheets as needed.
Applies To: Excel for Microsoft 365, Excel 2021, Excel 2019, Excel 2016, Excel 2013
Share things with nearby devices in Windows - Microsoft Support
On the PC you’re sharing from, select Start , and then select Settings > System > Nearby sharing .Choose whether you’d like to be able to share and receive files with everyone, or only your own devices (where you are logged in with your Microsoft account).
How to correct a #VALUE! error - Microsoft Support
Check your computer's date settings. Excel uses your computer's date system. If a cell's date isn't entered using the same date system, Excel won't recognize it as a true date.
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
CONCATENATE function - Microsoft Support
Problem. Description. Quotation marks appear in result string. Use commas to separate adjoining text items. For example: Excel will display =CONCATENATE("Hello ""World") as Hello"World with an extra quote mark because a comma between the text arguments was omitted.
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