Use the XLOOKUP function when you need to find things in a table or a 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.

Click the Printing Options tab.. The printer driver tells Word which way the envelope should be loaded into the printer, and this information is displayed in the Printing Options tab of the Envelope Options dialog box.. 1. The feed method determines the position of the envelope (right, middle, left) and whether the long or short edge is being fed into the printer.

Sign in to www.office.com from a web browser and start using the apps on the web or access other web services associated with your account such as OneDrive.. How you sign in to an installed Office app depends on your device.

The FILTER function allows you to filter a range of data based on criteria you define.

Note: If you use a Manual Table of Contents style, Word won't use your headings to create a table of contents and won't be able to update it automatically. Instead, Word will use placeholder text to create the look of a table of contents so you can manually type each entry into the table of contents.

When you initially setup your Windows device, you might have opted to use a local account instead of a Microsoft account. The main difference between a local account and a Microsoft account is that a local account is specific to one device, while a Microsoft account can be used across multiple devices and Microsoft services.

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

Analyze Data in Excel empowers you to understand your data through high-level visual summaries, trends, and patterns. Simply click a cell in a data range, and then click the Analyze Data button on the Home tab. Analyze Data in Excel will analyze your data, and return interesting visuals about it in a task pane.

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

TCP/IP defines how your PC communicates with other PCs. To make it easier to manage TCP/IP settings, we recommend using automated Dynamic Host Configuration Protocol (DHCP).