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
Shut down, sleep, or hibernate your PC - Microsoft Support
Turn your PC off completely. To shut down, select Start and then select Power > Shut down.. Sleep. Sleep uses very little power, your PC starts up faster, and you’re instantly back to where you left off.
Get the latest Windows update - Microsoft Support
Windows devices may get new functionality at different times as Microsoft delivers non-security updates, fixes, improvements, and enhancements via several servicing technologies—including controlled feature rollout (CFR).. Windows will let you know if you need to restart your device to complete an update, and you can choose a time that works best for you to complete that update.
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
Fix common Surface problems using the Surface app and Surface ...
Access, download, or run the Surface app and the Surface Diagnostic Toolkit to help find and solve Surface problems.
Fix Bluetooth problems in Windows - Microsoft Support
Troubleshoot problems with Bluetooth accessories. If you can turn on Bluetooth but having problems pairing or using a Bluetooth accessory, try the following steps to try to fix common problems with Bluetooth accessories.
Use the Office offline installer - Microsoft Support
Step 2. Install Office. Select the Microsoft 365 folder from the virtual drive and then double-click either the Setup32.exe to install the 32-bit version of Microsoft 365, or Setup64.exe to install the 64-bit version to begin the offline installation. If you're not sure which version is right for you, see Choose the 64-bit or 32-bit version of Office. ...
Applies To: Office 2021, Office 2019, Office 2016, Microsoft 365 for home, Office for business, Office 365 Small Business, Microsoft 365 admin, Office 365 operated by 21Vianet, Office 365 operated by 21Vianet - Small Business Admin, Office 365 operated by 21Vianet - Admin, Office 365 Germany - Enterprise, Office 365 Germany - Enterprise admin
How to start a scan for viruses or malware in Microsoft Defender
Tips: If you want a deeper scan, instead of selecting Quick scan in step 3, select Scan options and choose the type of scan you want.. For the most complete scan, run Microsoft Defender Offline. For more about that see Help protect my PC with Microsoft Defender Offline.
Applies To: Microsoft Defender on Android, Microsoft Defender on Mac, Microsoft Defender on Windows
Free up drive space in Windows - Microsoft Support
Note: If it’s been fewer than 10 days since you upgraded to Windows 10, your previous version of Windows will be listed as a system file you can delete.If you need to free up drive space, you can delete it, but keep in mind that you'll be deleting your Windows.old folder, which contains files that give you the option to go back to your previous version of Windows.
Install and use a scanner in Windows 10 - Microsoft Support
Select Add a printer or scanner.. Wait for it to find nearby scanners, then choose the one you want to use and select Add device.