Enable TPM 2.0 on your PC - Microsoft Support
How to enable TPM. If you need to enable TPM, these settings are managed via the UEFI BIOS (PC firmware) and vary based on your device. You can access these settings by choosing: Settings > Update & Security > Recovery > Restart now. From the next screen, choose Troubleshoot > Advanced options > UEFI Firmware Settings > Restart to make the changes.
Import photos and videos - Microsoft Support
Note for iPhone: If you are having trouble with your iPhone import, make sure your device is unlocked and you’ve accepted the permissions. Note for Android and other devices: If you’re using an Android phone or other device and import isn’t working, you might need to change your phone’s USB settings from Charging over USB to Transfer Files or Transfer Photos.
Keyboard shortcuts in Microsoft Edge - Microsoft Support
Ctrl + T. Open a new tab and switch to it. Ctrl + Shift + T. Reopen the last closed tab, and switch to it. Alt + Shift + T. Set focus on the first item in the app bar toolbar. Ctrl + U. View source. Ctrl + Shift + U. Start or stop Read Aloud. Ctrl + Shift + V. Paste without formatting. Ctrl + W. Close the current tab. Ctrl + Shift + W. Close ...
Add a printer or scanner in Windows - Microsoft Support
Learn how to add a printer or scanner in Windows. If your printer connects by a wire, plug it into your device. It'll connect automatically, your PC will download the right drivers, and you can use it right away.
如何登录到 Hotmail - Microsoft 支持
若要在 Outlook.com 中获取支持,请单击此处或选择菜单栏上的帮助,然后输入查询。 如果自助服务无法解决问题,请向下滚动到“仍需要帮助?”,然后选择“是”。 若要在 Outlook.com 中联系我们,需要登录。
Applies To: Outlook.com
Create and add an email signature in Outlook - Microsoft Support
Under Choose default signature, set the following options.. In the E-mail account drop-down box, choose an email account to associate with the signature. You can have different signatures for each email account. You can have a signature automatically added to all new messages. Go to in the New messages drop-down box and select one of your signatures. If you don't want to automatically add a ...
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016, Office for business, Office 365 Small Business, Microsoft 365 admin, Outlook on the web, Outlook.com, New Outlook for Windows, Outlook on the web for Exchange Server 2016, Outlook on the web for Exchange Server 2019
Use conditional formatting to highlight information in Excel
Notes: The formatting options that appear in the Formatting tab depend on the data you have selected. If your selection contains only text, then the available options are Text, Duplicate, Unique, Equal To, and Clear.When the selection contains only numbers, or both text and numbers, then the options are Data Bars, Colors, Icon Sets, Greater, Top 10%, and Clear.
Applies To: Excel for Microsoft 365, Excel for the web, Excel 2021, Excel 2019, Excel 2016
Install Office updates - Microsoft Support
Note: If you can't open an app to check your installation type, try the more common Click-to-Run or MSI uninstall steps first. Create or open an existing file and select File > Account (or it might say Office Account). Under Product information, find the About button and check for the following:
Applies To: Excel for Microsoft 365, Word for Microsoft 365, Outlook for Microsoft 365, PowerPoint for Microsoft 365, Access for Microsoft 365, OneNote for Microsoft 365, Excel 2021, Word 2021, Outlook 2021, PowerPoint 2021, Access 2021, Office 2021, OneNote 2021, Excel 2019, Word 2019, Outlook 2019, PowerPoint 2019, Access 2019, Office 2019, Excel 2016, Word 2016, Outlook 2016, PowerPoint 2016, Access 2016, OneNote 2016, Project Professional 2016, Project Standard 2016, Office 2016, Microsoft 365 for home, Office for business, Office 365 Small Business, Microsoft 365 admin, Office 365 operated by 21Vianet, InfoPath 2013, InfoPath Filler 2013
Look up values with VLOOKUP, INDEX, or MATCH - Microsoft Support
The fourth argument is empty, so the function returns an approximate match. If it didn't, you'd have to enter one of the values in columns C or D to get a result at all. When you're comfortable with VLOOKUP, the HLOOKUP function is equally easy to use. You enter the same arguments, but it searches in rows instead of columns.
Applies To: Excel for Microsoft 365, Excel for the web, Excel 2021, Excel 2019, Excel 2016
Insert a signature - Microsoft Support
Scan the page and save it on your computer in a common file format: .bmp, .jpg, or .png. For information on how to use your scanner, use the manufacturer’s manual or Web site.
Applies To: Word for Microsoft 365, Word for Microsoft 365 for Mac, Word 2021, Word 2021 for Mac, Word 2019, Word 2019 for Mac, Word 2016