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 2021, Excel 2021 for Mac, Excel 2019, Excel 2016, Excel for iPad, Excel for iPhone, Excel for Android tablets, Excel for Android phones
Filter junk email and spam in Outlook - Microsoft Support
When you mark email as junk, you can report the message to Microsoft to help improve the accuracy of the junk email filter. To set junk email reporting options, select Settings > Mail > Automatic processing > Junk email reporting.. Specify when to send junk email reports
Applies To: Office for business, Office 365 Small Business, New Outlook for Windows, Outlook on the web for Exchange Server 2016, Outlook on the web for Exchange Server 2019
OneDrive desktop app for Windows - Microsoft Support
Windows 10 . Select the Start button, type Programs and select Add or remove programs in the list of results.. Under Apps & features, find and select Microsoft OneDrive, and then select Uninstall.. If you don't see OneDrive in the list, press the Windows key and R to open a Run dialog, then type appwiz.cpl and press OK.
Set up rules in Outlook - Microsoft Support
Select a condition, and what to do with the message based on the condition. For example, to move messages with a certain title to a specific folder, select the Subject contains condition, select Move the item to folder, select or create a New folder, and then select OK.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016
Protect yourself from tech support scams - Microsoft Support
The classic cold-call scam. The scammers call you and claim to be from the tech support team of Microsoft or another company. They offer to help solve your computer "problems".
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 2021, Word 2019, Word 2016, Word 2013
在 Windows 中卸载或删除应用和程序 - Microsoft 支持
可通过不同的方式删除应用和程序,因此如果找不到要查找的应用和程序,可以尝试另一个位置。 请注意,某些应用和程序内置于 Windows 中,无法卸载。
Encrypt messages by using S/MIME in Outlook on the web
Install the S/MIME control. Get a certificate, sometimes referred to as a key or digital ID. The first step to use S/MIME is to obtain a certificate from your IT administrator or helpdesk.
Applies To: Outlook.com, Outlook on the web for Exchange Server 2016, Outlook on the web for Exchange Server 2019
Create or run a macro - Microsoft Support
To save time on tasks you do often, bundle the steps into a macro. First, you record the macro. Then you can run the macro by clicking a button on the Quick Access Toolbar or pressing a combination of keys.
Applies To: Word for Microsoft 365, Word for the web, Word 2021, Word 2019, Word 2016
Change the column width or row height in Excel
Note: The boundary is the line between cells, columns, and rows.If a column is too narrow to display the data, you will see ### in the cell.
Applies To: Excel for Microsoft 365, Excel 2021, Excel 2019, Excel 2016