Use the XLOOKUP function to find things in a table or range by row. For example, look up the price of an automotive part by the part number, or find an employee name based on their employee ID. With XLOOKUP, you can look in one column for a search term and return a result from the same row in another column, regardless of which side the return column is on.

Most of the time, Excel will recognize this, and you'll see an alert next to the cell where numbers are being stored as text. If you see the alert:

扩展或加载项是自定义浏览器体验并为你提供更多控制权的简单工具。 下面介绍如何在 Microsoft Edge 中添加、关闭和删除扩展或加载项 。

If your account has been hacked, use our sign-in helper tool below to help guide you to the right solutions. The tool will ask for your email address or phone number, and either show appropriate self-help, or offer the chance to talk to an agent.

Automatically fill a series of data in your worksheet, like dates, numbers, text, and formulas. Use the AutoComplete feature, Auto Fill Options button and more.

Establishing internet boundaries is an important way to protect yourself and your family from inappropriate web content. Microsoft Family Safety web and search filters work across any Windows, Xbox and mobile device that has the Microsoft Edge browser and Family Safety apps installed.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

In the Save As dialog box, in the Save as type list, select Outlook Template.

Examples. See various examples in the figure below. Look closely at the use of the TEXT function in the second example in the figure. When you join a number to a string of text by using the concatenation operator, use the TEXT function to control the way the number is shown. The formula uses the underlying value from the referenced cell (.4 in this example) — not the formatted value you see ...

A family group is a set of individuals connected through the Microsoft Family Safety app on their Windows, Xbox, or mobile devices. Establishing a family group is an easy, effective way to encourage healthy online habits and manage busy schedules.