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
Set up the Microsoft Authenticator app as your verification method
Method. Used for. Authenticator app. Two-factor verification and password reset authentication. Text messages. Two-factor verification and password reset authentication.
Import and export Outlook email, contacts, and calendar
Export contacts out of other email services. Export iCloud contacts. Export Gmail contacts – See Gmail help. Export Yahoo contacts – See Yahoo import and export help. Export Thunderbird contacts – See Mozilla support.
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 2013, Outlook.com
Contact Us - Microsoft Support
Contact Microsoft Support. Find solutions to common problems, or get help from a support agent.
Sign in and create multiple profiles in Microsoft Edge
With Edge Chromium, you can add multiple profiles. Profiles allow multiple users to operate in a shared environment while maintaining access to their personalized browser settings, bookmarks, and extensions.
Back up your folders with OneDrive - Microsoft Support
Set up PC folder backup. Open OneDrive settings (select the OneDrive cloud icon in your notification area, and then select the OneDrive Help & Settings icon then Settings.). Open OneDrive settings (select the OneDrive cloud icon in your notification area, and then select the OneDrive Help and Settings icon then Settings.)
Applies To: OneDrive for Business, Microsoft 365 admin, OneDrive (work or school), OneDrive (home or personal), OneDrive for Mac, OneDrive for Windows
Add and request read receipts and delivery notifications in Outlook
A delivery receipt confirms delivery of your email message to the recipient's mailbox, but not that the recipient has seen it or read it. A read receipt confirms that your message was opened.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016, Outlook on the web, Outlook.com, New Outlook for Windows, Outlook on the web for Exchange Server 2016, Outlook on the web for Exchange Server 2019
Microsoft .NET Framework 4.7.2 offline installer for Windows
Issues that are fixed in this update. The following issues are fixed for .NET Framework 4.7.2. SQL Server (SQL) Fixes an issue in which the .NET Framework API SqlConnection.ConnectionString property is used to set a null or empty connection string. In this situation, a Null Reference Exception (NRE) occurs when you use the API together with .NET Framework 4.7.2.
CONCATENATE function - Microsoft Support
Important: In Excel 2016, Excel Mobile, and Excel for the web, this function has been replaced with the CONCAT function.Although the CONCATENATE function is still available for backward compatibility, you should consider using CONCAT from now on. This is because CONCATENATE may not be available in future versions of Excel.
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
Restore deleted files or folders in OneDrive - Microsoft Support
If you accidentally delete a file or folder in OneDrive, you may be able to recover it later from the OneDrive recycle bin.. For info about restoring a SharePoint file or folder, see how to restore items from the SharePoint recycle bin.For info about restoring SharePoint files stored in OneDrive, see Restore a previous version of a file in OneDrive.
Applies To: OneDrive for Business, SharePoint Server Subscription Edition, SharePoint Server 2019, OneDrive (work or school), OneDrive (home or personal), OneDrive (work or school) operated by 21Vianet, OneDrive for Mac, OneDrive for Windows