VLOOKUP function - Microsoft Support
Argument name. Description. lookup_value (required). The value you want to look up. The value you want to look up must be in the first column of the range of cells you specify in the table_array argument. For example, if table-array spans cells B2:D7, then your lookup_value must be in column B.. Lookup_value can be a value or a reference to a cell.. table_array (required)
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 2019 for Mac, Excel 2016
New and classic Outlook for Windows feature comparison
We are actively listening to your feedback and will make updates and changes to our feature roadmap based on what you tell us. If you have feedback on what we should consider adding to new Outlook, please use the in-app Help > Give Feedback link.. Feature comparison
Applies To: Outlook for Microsoft 365, New Outlook for Windows
Check or change language settings - Microsoft Support
Microsoft's products and services work best if you use the same language and region across all your devices, and in all of your app and Store settings.
Applies To: Outlook.com, Microsoft Edge, OneDrive (home or personal)
Customize keyboard shortcuts - Microsoft Support
Important: Reassigning a combination of keys means that you can no longer use the combination for its original purpose.For example, pressing CTRL+B changes selected text to bold. If you reassign CTRL+B to a new command or other item, you will not be able to make text bold by pressing CTRL+B unless you restore the keyboard shortcut assignments to their original settings by selecting Reset All ...
Applies To: Word for Microsoft 365, Word 2021, Word 2019, Word 2016
Insert a horizontal line - Microsoft Support
Type three of the characters shown below, and then press Enter. The line is inserted for the full width of the page. When inserted into a column, the line is inserted to match the width of the column.
Applies To: Word for Microsoft 365, Outlook for Microsoft 365, Word 2021, Outlook 2021, Word 2019, Outlook 2019, Word 2016, Outlook 2016
Open and run DxDiag.exe - Microsoft Support
Learn how to open and run DxDiag.exe on Windows to collect device information and troubleshoot DirectX sound and video issues.
Find all your apps and programs - Microsoft Support
Looking for a long-lost app or program? There are several ways you can find what you need. Select Start , and then scroll through the alphabetical list on the left (if your Start screen is set to show as full screen, select All apps, and then scroll through the list).
Change the capitalization or case of text - Microsoft Support
PowerPoint for the web supports changing case. See the procedure below. Word for the web doesn't support changing case. Use the desktop application to open the document and change text case there, or else you can manually change the casing of text in Word for the web.
Applies To: Word for Microsoft 365, PowerPoint for Microsoft 365, Word for Microsoft 365 for Mac, PowerPoint for Microsoft 365 for Mac, Word for the web, PowerPoint for the web, Word 2021, PowerPoint 2021, Word 2021 for Mac, PowerPoint 2021 for Mac, Word 2019, PowerPoint 2019, Word 2019 for Mac, PowerPoint 2019 for Mac, Word 2016, PowerPoint 2016
Back up your Windows PC - Microsoft Support
Step 2: Back up your folders. Windows Backup is an easy, single stop for all of your backup needs. Your free Microsoft account comes with 5 GB of OneDrive cloud storage (and more storage is available if you need it), and backing up your folders syncs the folders you specify to your OneDrive account, making them instantly accessible on all computers that you use with this Microsoft account.
Mouse and keyboard problems in Windows - Microsoft Support
Check the device. If the device doesn't appear to work at all (no lights appear on the device when it’s plugged in, or the cursor doesn't move or doesn't appear on the screen), connect the device to another PC and make sure the device works on that PC.