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.

Basic tasks in Excel. Excel is an incredibly powerful tool for getting meaning out of vast amounts of data. But it also works really well for simple calculations and tracking almost any kind of information. The key for unlocking all that potential is the grid of cells. Cells can contain numbers, text, or formulas.

If you can't find Internet Explorer on your device, you'll need to add it as a feature. Select Start > Search , and enter Windows features. Select Turn Windows features on or off from the results and make sure the box next to Internet Explorer 11 is selected. Select OK, and restart your device. Internet Explorer 11 support ended on June 15, 2022.

Explore Phone Link. Become a Windows Insider and get early access to the newest experiences in Phone Link. Learn more about accessibility options to help you use Phone Link in a way that best suits your needs. Learn more about the latest Phone Link features. Find time-saving hacks and explore how you can use Phone Link.

Select View > Freeze Panes > Freeze First Column. The faint line that appears between Column A and B shows that the first column is frozen. Freeze the first two columns. Select the third column. Select View > Freeze Panes > Freeze Panes. Freeze columns and rows. Select the cell below the rows and to the right of the columns you want to keep ...

Enter a formula that contains a built-in function. Select an empty cell. Type an equal sign = and then type a function. For example, =SUM for getting the total sales. Type an opening parenthesis (. Select the range of cells, and then type a closing parenthesis). Press Enter to get the result.

When you enable an add-in, it adds custom commands and new features to Microsoft 365 programs that help increase your productivity. Because add-ins can be used by attackers to do harm to your computer, you can use add-in security settings to help protect yourself.

Select Start > Settings > Apps > Apps & features. Apps & features in Settings. Select the More icon next to the app you want to fix. Select the Advanced options link under the name of the app (some apps don't have this option). On the page that opens, select Repair if it's available. If it isn't available or doesn't fix the problem, select Reset.

使用 CONCAT 函数合并数据. 选择要放置合并后数据的单元格。. 键入“ =CONCAT ( ”。. 首先选择要合并的单元格。. 使用逗号分隔要合并的单元格，使用引号添加空格、逗号或其他文本。. 在公式末尾添加括号，然后按 Enter。. 示例公式可能是“ =CONCAT (A2, " Family") ”。.

Other subscription plans. Besides Microsoft 365 Family or Personal, there are other Microsoft 365 plans which include additional benefits and features designed specifically for small and mid-size businesses, enterprises, schools, or non-profits. You also get 5 GB of OneDrive online cloud storage with your free Microsoft account so you can access your files from anywhere.