Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.
使用 VLOOKUP、INDEX 或 MATCH 查找值 - Microsoft 支持
使用 vlookup、hlookup 和其他函数(如 index 和 match)根据您输入的值搜索和查找数据。 本文将让您快速回顾 vlookup,然后链接到更多内容。
Applies To: Excel for Microsoft 365, Excel for the web, Excel 2021, Excel 2019, Excel 2016
Manage your Microsoft 365 subscription or Office product
You can manage all of your Microsoft subscriptions in your Microsoft account dashboard. Select each subscription to change when and how you pay, or to see order history & receipts.
Applies To: Excel for Microsoft 365, Word for Microsoft 365, Outlook for Microsoft 365, PowerPoint for Microsoft 365, Access for Microsoft 365, OneNote for Microsoft 365, Publisher for Microsoft 365, Visio Plan 2, Excel for Microsoft 365 for Mac, Word for Microsoft 365 for Mac, Outlook for Microsoft 365 for Mac, PowerPoint for Microsoft 365 for Mac, OneNote for Microsoft 365 for Mac, Word for the web, OneNote for the web, PowerPoint for the web, Excel 2021, Word 2021, Outlook 2021, Access 2021, Project Professional 2021, Project Standard 2021, Publisher 2021, Visio Professional 2021, Visio Standard 2021, Office 2021, OneNote 2021, Excel 2021 for Mac, Word 2021 for Mac, Outlook 2021 for Mac, OneNote 2021 for Mac, Office 2021 for Mac, Excel 2019, Word 2019, Outlook 2019, PowerPoint 2019, Access 2019, Project Professional 2019, Project Standard 2019, Publisher 2019, Visio Professional 2019, Visio Standard 2019, Office 2019, Excel 2019 for Mac, Word 2019 for Mac, Outlook 2019 for Mac, PowerPoint 2019 for Mac, OneNote 2019 for Mac, Office 2019 for Mac, Excel 2016, Word 2016, Outlook 2016, PowerPoint 2016, Access 2016, OneNote 2016, Project Professional 2016, Project Standard 2016, Publisher 2016, Visio Professional 2016, Visio Standard 2016, Office 2016, Microsoft 365 admin, Outlook on the web, Word Web App, Microsoft account dashboard, New Outlook for Windows
Add a list box or combo box to a worksheet in Excel
To set this property. Do this. Fill color. Click BackColor > the down arrow > Pallet, and then pick a color.. Font type, style or size. Click Font > the... button and pick font type, size, or style.. Font color. Click ForeColor > the down arrow > Pallet, and then pick a color.. Link a cell to display selected list value. Click LinkedCell. Link Combo Box to a list
Applies To: Excel for Microsoft 365, Excel 2021, Excel 2019, Excel 2016
How to sign out of your Microsoft account everywhere
If you think someone might have unauthorized access to your account, we can protect you by signing you out from all of your trusted devices. Within 24 hours, you will be signed out of browsers, apps and anywhere else your account is used to sign in, except an Xbox console.
Applies To: Microsoft account dashboard
Pair a Bluetooth device in Windows - Microsoft Support
In quick settings: To find the quick setting for Bluetooth, select the Network, Sound, or Battery icons ( ) next to the time and date on the right side of your taskbar.Select Bluetooth to turn it on. If it's turned on without any Bluetooth devices connected, it might appear as Not connected . If you don't see Bluetooth in quick settings, you might need to add it.
如何安装最新版本的 DirectX - Microsoft 支持
DirectX 9.0c 通过安装 DirectX 9.0c 最终用户运行时适用于 Windows XP 和 Windows Server 2003。. 某些应用程序和游戏需要 DirectX 9。 但是,你的计算机包含更新版本的 DirectX。 如果安装并运行需要 DirectX 9 的应用程序或游戏,你可能会收到错误消息“无法启动此程序,因为计算机中丢失 d3dx9_35.dll。
修复 Windows 中的声音或音频问题 - Microsoft 支持
修复 Windows 中的声音或音频问题; 设置 Microsoft 新式无线耳机; 在 Microsoft Teams 中使用 Microsoft 新式无线耳机; 在 Microsoft Teams 中使用 Microsoft 新式 USB-C 耳机
在 Excel 中将 IF 与 AND、OR 和 NOT 函数配合使用 - Microsoft 支持
但如果需要测试多个条件,例如我们假设所有条件都需要为 True 或 False (AND),或只有一个条件需要为 True 或 False (OR),或者如果想要检查某个条件是否不 (NOT) 符合你的条件,这时该怎么做呢?这三个函数均可以单独使用,但它们更常见于与 IF 函数成对使用。
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, Excel for Windows Phone 10
屏幕镜像和投影到电脑或无线显示器 - Microsoft 支持
注意: 无线显示应用在运行 Windows 11 版本 22H2 及更高版本的设备上可用。如果运行的是早期版本的 Windows,请在任务栏的搜索框中输入 “连接”,然后在结果列表中选择“连接”,从而启动 “连接” 应用。 若要了解正在运行的 Windows 版本,请参阅 我运行的是哪个版本的 Windows 操作系统?
Change or reset your password - Microsoft Support
Important: Microsoft accounts, the Windows operating system, and other Microsoft products include passwords to help secure your information.This article provides some options that you can use to reset or recover your password if you forget it. Be aware that, if these options don’t work, Microsoft support can't help you retrieve or circumvent a lost or forgotten password.