Personalize your lock screen - Microsoft Support
Elevate your device by showcasing beautiful images from around the globe with Windows spotlight, or your favorite memories with a custom photo or a dynamic slide show as your lock screen background.. Stay informed and efficient with dynamic updates that bring weather, finance, sports, traffic, and app notifications right to your lock screen.
Update your Xbox Wireless Controller
If instructions to install the update don’t automatically appear, you can start the process manually. To do this, press the Xbox button to open the guide, choose Profile & system > Settings > Devices & connections > Controllers & headsets, and then select the controller you want to update.On the Xbox Wireless Controller screen, select “…” to check the firmware version for your controller.
Count how often a value occurs - Microsoft Support
The COUNTIFS function is similar to the COUNTIF function with one important exception: COUNTIFS lets you apply criteria to cells across multiple ranges and counts the number of times all criteria are met. You can use up to 127 range/criteria pairs with COUNTIFS. The syntax for COUNTIFS is: COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2],…)
Applies To:
Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2024, Excel 2024 for Mac, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2016
How to sign out of your Microsoft account everywhere
If you think someone might have unauthorized access to your account, we can protect you by signing you out from all of your trusted devices. Within 24 hours, you will be signed out of browsers, apps and anywhere else your account is used to sign in, except an Xbox console.
Applies To:
Microsoft account dashboard
Change or reset your password - Microsoft Support
Important: Microsoft accounts, the Windows operating system, and other Microsoft products include passwords to help secure your information.This article provides some options that you can use to reset or recover your password if you forget it. Be aware that, if these options don’t work, Microsoft support can't help you retrieve or circumvent a lost or forgotten password.
Add, turn off, or remove extensions in Microsoft Edge
Learn how to manage extensions in Microsoft Edge, including adding, disabling, or removing them as needed.
Auto color management in Windows 11 - Microsoft Support
Creative professionals and enthusiasts care about fully calibrated, accurate colors because it helps to make sure colors remain consistent from the beginning to the end of their projects.
Fix problems that block programs from being installed or removed
The Program Install and Uninstall troubleshooter helps you automatically repair issues when you're blocked from installing or removing programs.
How do I upgrade Office? - Microsoft Support
If your current version of Office is a one-time purchase (non-subscription) version of Office such as Office Home & Student or Office Home & Business, to upgrade, you'll need to buy the latest version.
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, Project Online Desktop Client, Publisher for Microsoft 365, Visio Plan 2, Excel for Microsoft 365 for Mac, Word for Microsoft 365 for Mac, Outlook for Microsoft 365 for Mac, PowerPoint for Microsoft 365 for Mac, Excel 2016, Word 2016, Outlook 2016, PowerPoint 2016, Access 2016, OneNote 2016, Project Professional 2016, Project Standard 2016, Publisher 2016, Visio Professional 2016, Visio Standard 2016, Office 2016, Excel 2016 for Mac, Word 2016 for Mac, Outlook 2016 for Mac, PowerPoint 2016 for Mac, OneNote 2016 for Mac, Office 2016 for Mac, Excel 2013, Word 2013, Outlook 2013, PowerPoint 2013, Access 2013, OneNote 2013, Visio Professional 2013, Visio 2013, Office 2013, 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, Project Online, Microsoft 365 for Mac, Office 365 Germany - Enterprise, Office 365 Germany - Enterprise admin
External or guest sharing in OneDrive, SharePoint, and Lists
If you want to secure your content and get a link that only works for the people you invite, select Specific people in Link settings when creating the sharing link.. The recipients' experience depends on the settings you select when creating the sharing link, and the account they use to view the file.
Applies To:
Microsoft Lists, OneDrive (work or school), OneDrive for Mac, OneDrive for Windows