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.
XLOOKUP 函数 - Microsoft 支持
需要在表格中或按行查找内容时,请使用 vlookup 函数。 例如,按部件号查找汽车部件的价格,或根据员工 id 查找员工姓名。 借助 xlookup,你可以在一列中查找搜索词,并在同一行的另一列中返回结果,无论返回结果的列在原列的哪一侧。
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
绝对交集运算符: @ - Microsoft 支持
了解隐式交集运算符 (@) ,该运算符使用称为隐式交集的逻辑返回单个值。 隐式交集运算符 (@) 可能会返回值、单个单元格区域或错误。 隐式交集运算符 (@) 位于称为动态数组的函数类中。
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2019, Excel 2016
Share your network printer - Microsoft Support
In Windows 10, you can share your printer with many PCs on your network. To share a printer from the PC that the printer is connected to (the primary PC) with secondary PCs that the printer is not connected to, you must set up sharing settings for the printer, connect the printer to the primary PC (either wirelessly or by using a USB cable), and then turn on the printer.
Create a simple formula in Excel - Microsoft Support
You can create a simple formula to add, subtract, multiply or divide values in your worksheet. Simple formulas always start with an equal sign (=), followed by constants that are numeric values and calculation operators such as plus (+), minus (-), asterisk (*), or forward slash (/) signs.The following is an example of a simple formula.
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2019 for Mac, Excel 2016
Change privacy settings in Windows - Microsoft Support
Explore subscription benefits, browse training courses, learn how to secure your device, and more.
Account help
Microsoft account help and support. Get help with signing in, locked or compromised accounts, linked accounts, closing, reopening, and updating your security info and account profile.
如何在 Windows 11 中使用专注 - Microsoft 支持
专注是 Windows 11 中的一项新功能,可帮助你最大程度地减少干扰。 为了帮助你保持专注,它集成了“时钟”应用,具有专注计时器和音乐集成等功能。
如何兑换礼品卡和代码 | Xbox Support
按“开始”按钮 ,然后在“搜索”框中输入“Xbox”。 从结果中选择 Xbox 应用以打开该应用。; 选择左上角的玩家图片,然后选择“设置”。 在“兑换代码”下选择“兑换”。 输入由 25 个字符组成的代码,选择 下一步,然后按照提示操作。
Repair Outlook Data Files (.pst and .ost) - Microsoft Support
Note: The scan creates a backup file during the repair process.To change the default name or location of this backup file, in the Enter name of backup file box, enter a new name, or choose Browse to select the file you want to use. You may need to run the tool several times in order to repair your Outlook Data File.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016
FILTER function - Microsoft Support
In the following example we used the formula =FILTER(A5:D20,C5:C20=H2,"") to return all records for Apple, as selected in cell H2, and if there are no apples, return an empty string ("").
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2021 for Mac, Excel for iPad, Excel for iPhone, Excel for Android tablets, Excel for Android phones