XLOOKUP function - Microsoft Support
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.
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
Find and install your Microsoft downloads from Microsoft Store
Most software that you buy directly from Microsoft, like Office, Windows, and Xbox games, comes as a digital download that you can download, install, or reinstall.
Applies To: Microsoft account dashboard
Add or remove items from a drop-down list - Microsoft Support
After you update a drop-down list, make sure it works the way you want. For example, check to see how to Change the column width and row height to show your updated entries. If the list of entries for your drop-down list is on another worksheet and you want to prevent users from seeing it or making changes, consider hiding and protecting that worksheet.
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
Troubleshoot Windows Media Player Errors - Microsoft Support
Repair or reset Windows Media Player: If Windows Media Player is not working properly, you can try to repair or reset it to its default settings.To do this, Select Start > Settings > Apps > Installed Apps.. Scroll down and click the three horizontal dots next to Windows Media Player and choose Advanced options, and click the Repair or Reset button. Note that resetting Windows Media Player will ...
Download free, pre-built templates - Microsoft Support
Find and download free templates to create documents like calendars, business cards, letters, greeting cards, brochures, newsletters, or resumes.
Applies To: Excel for Microsoft 365, Word for Microsoft 365, PowerPoint for Microsoft 365, Access for Microsoft 365, Project Online Desktop Client, Publisher for Microsoft 365, Excel 2021, Word 2021, PowerPoint 2021, Access 2021, Project Professional 2021, Project Standard 2021, Publisher 2021, Excel 2019, Word 2019, PowerPoint 2019, Access 2019, Project Professional 2019, Project Standard 2019, Publisher 2019, Excel 2016, Word 2016, PowerPoint 2016, Access 2016, Project Professional 2016, Project Standard 2016, Publisher 2016, Visio Professional 2016, Visio 2010, InfoPath 2013
How do I log on as an administrator? - Microsoft Support
Open User Accounts by clicking the Start button , clicking Control Panel, clicking User Accounts and Family Safety, clicking User Accounts, and then clicking Manage another account .. If you're prompted for an administrator password or confirmation, type the password or provide confirmation.
Use voice typing to talk instead of type on your PC
To Insert this. Say this ' 撇 號 . 上 標 點 . 略 縮 號 -減 號 . 連 字 號 ! 感 歎 號 . 驚 嘆 號 # 井 字 號 $ 美 元 符 號 % 百 分 號
Find your IP address in Windows - Microsoft Support
For Wi-Fi connection. Select Start > Settings > Network & internet > Wi-Fi and then select the Wi-Fi network you're connected to.
Install Windows 7 Service Pack 1 (SP1) - Microsoft Support
The recommended (and easiest) way to get SP1 is to turn on automatic updating in Windows Update in Control Panel and wait for Windows 7 to notify you that SP1 is ready to install.
Use System Restore - Microsoft Support
Use System restore to make restore points when you install a new app, driver, or Windows update, and when you create a restore point manually.