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
OneDrive won't start - Microsoft Support
In order to sync with OneDrive for work or school, the DisableFileSyncNGSC key must be removed or the DWORD value must be changed to 0 (zero). If the registry value was set as part of a Group Policy Object, the policy must be removed.
Applies To: SharePoint in Microsoft 365
How to start a scan for viruses or malware in Microsoft Defender
Tips: If you want a deeper scan, instead of selecting Quick scan in step 3, select Scan options and choose the type of scan you want.. For the most complete scan, run Microsoft Defender Offline. For more about that see Help protect my PC with Microsoft Defender Offline.
Applies To: Microsoft Defender on Android, Microsoft Defender on Mac, Microsoft Defender on Windows
Reset OneDrive - Microsoft Support
Important: You won't lose files or data by resetting OneDrive on your computer.Resetting OneDrive only disconnects all your sync connections (including personal and work or school).
Applies To: OneDrive for Business, SharePoint Server Subscription Edition, SharePoint Server 2019, SharePoint in Microsoft 365, OneDrive (work or school), OneDrive (home or personal), OneDrive (work or school) operated by 21Vianet, OneDrive for Mac, OneDrive for Windows
Complete guide to Narrator - Microsoft Support
Text recognition in images is enhanced, including handwriting recognition, and overall image descriptions are better. To experience the improved experience, navigate to any image and, while the image is in focus, execute the keyboard combination "Narrator key+CTRL+d “. . An active internet connection is necessary for this feature, and Narrator settings must have the option to obtain Image ...
What is the Recent activity page? - Microsoft Support
If you travel often, your new locations may show as unusual activity. To travel without disruptions or alerts, we recommend using Microsoft Authenticator to sign in.. If you get an email about unusual activity and you're not sure if it's from Microsoft, you can safely sign in to your Microsoft account any time without clicking links in the email.
Applies To: Microsoft account dashboard
Import or export text (.txt or .csv) files - Microsoft Support
Import a text file by opening it in Excel. You can open a text file that you created in another program as an Excel workbook by using the Open command. Opening a text file in Excel does not change the format of the file — you can see this in the Excel title bar, where the name of the file retains the text file name extension (for example, .txt or .csv).
Applies To: Excel for Microsoft 365, Excel 2021, Excel 2019, Excel 2016
Use Image Creator in Paint to generate AI art - Microsoft Support
Using Image Creator. To use Image Creator, open Microsoft Paint and select the Image Creator icon on the toolbar to see the side panel.In the text box, enter a description of the image you want to create. For example, you can type "a blue cat with a red hat" or "a landscape with mountains and a lake".
Manage your contacts with the People App in Teams
Use the People App to organize, add, create, view, and edit contacts. Getting to the People App To access the app, go to View more apps on the left side of Teams. Search for “people” or select it from the list of preinstalled apps.
Applies To: Microsoft Teams
June 28, 2024—KB5039304 (OS Build 26100.1000) Preview
For information about Windows update terminology, see the article about the types of Windows updates and the monthly quality update types. Note Follow @WindowsUpdate to find out when new content is published to the Windows release health dashboard.