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
Use live captions in Microsoft Teams meetings
In this article. Live captions in Teams. Live caption settings. Set up live translated captions. Use live translated captions. Customize captions. Live captions in Teams
Applies To:
Microsoft Teams
Pairing an Xbox controller to your console | Xbox Support
You have two options for connecting your Xbox Wireless Controller to your console: using the console’s Pair button for a wireless connection and using a USB to micro-USB cable (or USB to USB-C cable) for a wired connection.
Use Cocreator in Paint - Microsoft Support
Sign-in requirement This feature makes use of the Neural Processing Unit (NPU) to generate images locally on your computer. There are no restrictions on how many images you can generate. However, to use Cocreator, you need to sign in with your Microsoft account and be connected to the internet to access cloud services that ensure safe use of AI. ...
Add an exclusion to Windows Security - Microsoft Support
If you trust a file, file type, folder, or a process that Windows Security has detected as malicious, you can stop Windows Security from alerting you or blocking the program by adding the file to the exclusions list.
Manually add an account to the Microsoft Authenticator app
Add your work or school account. On your computer, note the Code and Url information on the Configure mobile app page.Keep this page open so you can see the code and URL.
Устранение неисправностей Bluetooth-подключений в Windows
Устранение неполадок с аксессуарами Bluetooth. Если вы можете включить Bluetooth, но у вас возникают проблемы со связыванием или использованием аксессуара Bluetooth, см. следующие действия, которые помогут вам устранить ...
Getting started with Planner in Teams - Microsoft Support
Track your tasks in My Tasks. Planner offers a purpose-built My Tasks view, designed to centralize all the tasks relevant to you. My Tasks is organized into four distinct views, each serving a unique purpose: Private tasks: Private tasks is a place for you to quickly jot down tasks at the speed of thought.This is a place where you can create tasks that do not belong to a plan yet.
Applies To:
Microsoft Planner, Microsoft Teams, Microsoft Teams for Education, Microsoft Teams personal, Microsoft Teams small business
Cooking up a great prompt: Getting the most from Copilot
Generating content ideas. Lead with broader requests, then give specific details about the content. Gaining insights. Ask for a summary of a specific file, then ask relevant questions to gain deeper insights.
Empty the Recycle Bin in Windows 10 - Microsoft Support
Right click (or press and hold) and select Empty Recycle Bin.