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.

After you set up your security verification methods for your work or school account, you can update the related details. Using the Security info page

键盘快捷方式是键或键组合，提供了一种替代通常使用鼠标完成的任务的替代方法。 如果要拍摄屏幕截图或截屏，请参阅 如何获取屏幕截图并向其添加注释。. 本文包括分类为的键盘快捷方式列表：

Move or copy cells and cell contents Article; Change the column width or row height in Excel Article; Find or replace text and numbers on a worksheet

Erfahren Sie, wie Sie einen Windows-Product Key für die Aktivierung finden und wann Sie stattdessen eine digitale Lizenz verwenden.

Argument name. Description. Sum_range (required). The range of cells to sum. Criteria_range1 (required). The range that is tested using Criteria1.. Criteria_range1 and Criteria1 set up a search pair whereby a range is searched for specific criteria. Once items in the range are found, their corresponding values in Sum_range are added.. Criteria1 (required)

List view. A unique feature of the Tasks app how it displays tasks and information associated with them in rows and columns. This is called List view, and allows you to change many tasks at once, which wasn't as possible in either To Do or Planner before.

Note: If a document has been shared with you for review, you may not be able to turn off Track Changes.If you want to edit the document without tracking changes, you’ll need to either save a copy or ask the person who sent it to you to share it again with review mode turned off.

Show the Developer tab. If the developer tab isn't already visible, see Show the Developer tab.. Make your list. Type the list.

Using clipboard. When you copy content on your PC, it’s automatically copied to your clipboard for you to paste. You can paste multiple items from your clipboard history, and you can also pin the items you tend to use all the time and sync your clipboard history to the cloud.