XLOOKUP function - Microsoft Support
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.
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2024, Excel 2024 for Mac, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2016, Excel for iPad, Excel for iPhone, Excel for Android tablets, Excel for Android phones
Share your Microsoft 365 Family subscription - Microsoft Support
Sharing is only possible if the invitee joins the subscription owners' family group. If the invitee is already in another family group, they will need to leave it to join the subscription owners' family group.. Once the invitee has joined the family group, then the subscription owner can share the Microsoft 365 Family benefits.
Applies To: Excel for Microsoft 365, Word for Microsoft 365, PowerPoint for Microsoft 365, Excel for Microsoft 365 for Mac, Word for Microsoft 365 for Mac, PowerPoint for Microsoft 365 for Mac, Microsoft 365 for home, Office for business, Microsoft account dashboard
Signing in with a passkey - Microsoft Support
What are passkeys? Passkeys are a replacement for your password. With passkeys, you can sign into your Microsoft personal account, or your work/school account using your face, fingerprint, or PIN.
Applies To: Microsoft account dashboard
Contact - Microsoft Support
Contact Microsoft Support. What's new. Surface Pro; Surface Laptop; Surface Laptop Studio 2
Manage your household budget in Excel - Microsoft Support
The purpose of a household budget is to summarize what you earn against what you spend to help you plan for long and short-term goals. Using a budgeting spreadsheet can help make your financial health a priority by keeping spending in check and savings on the rise!
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web
Block pop-ups in Microsoft Edge - Microsoft Support
The Microsoft Edge feature that blocks pop-ups is effective in preventing websites from automatically opening a new window or tab, or a partial window on top of your current web page. This feature is turned on by default. There are many different types of pop-ups, including advertisements, notices, offers, or alerts that can appear at various times on any web page. Some can be helpful, such as ...
Applies To: Microsoft account dashboard
KB5003791: Update to Windows 10, version 21H2 by using an enablement ...
Summary. Windows 10, versions 2004, 20H2, 21H1, and 21H2 share a common core operating system with an identical set of system files. Therefore, the new features in Windows 10, version 21H2 are included in the latest monthly quality update for Windows 10, version 2004, 20H2, and 21H1, but are in an inactive and dormant state.
Play a CD or DVD in Windows Media Player - Microsoft Support
Note: If you start to play a DVD or VCD in the Player Library, the Player automatically switches to Now Playing mode. The Blu-ray Disc format is not supported in Windows Media Player. To play a Blu-ray Disc, you need to use a non-Microsoft program that supports Blu-ray playback and a device capable of reading Blu-ray Discs.
Create and print a single envelope - Microsoft Support
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.
Applies To: Word for Microsoft 365, Word 2024, Word 2021, Word 2019, Word 2016, Word 2013
View printer queue in Windows - Microsoft Support
Find out how to view the printer queue in Windows.