Sort data in a range or table - Microsoft Support
To specify the next cell color, font color, or icon to sort by, click Add Level, and then repeat steps three through five.. Make sure that you select the same column in the Then by box and that you make the same selection under Order.. Keep repeating for each additional cell color, font color, or icon that you want included in the sort.
Applies To: Excel for Microsoft 365, Excel for the web, Excel 2021, Excel 2019, Excel 2016
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.
Help in WordPad - Microsoft Support
Get answers to common questions about WordPad. Here are a few tips to help you use WordPad: To open and save files, select File, then select New to create a new document, Open to work with an existing document, or Save to save your document.(If your document doesn't have a name, WordPad will ask you to provide one.)
Set up your Microsoft 365 sign-in for multi-factor authentication
By setting up MFA, you add an extra layer of security to your Microsoft 365 account sign-in. For example, you first enter your password and, when prompted, you also type a dynamically generated verification code provided by an authenticator app or sent to your phone.
Applies To: Office for business, Microsoft 365 admin
Open and find items in an Outlook Data File (.pst)
Expand the top level of the Outlook data file in the Outlook Navigation pane to see the subfolders in the file. Click each subfolder to see the contents.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016
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 2021, Excel 2021 for Mac, Excel 2019, Excel 2019 for Mac, Excel 2016
Fix network connection issues in Windows - Microsoft Support
Try these things to troubleshoot network connection issues in Windows 11. Make sure Wi-Fi is on. Select Start > Settings > Network & internet, then turn on Wi-Fi.Next, select More options (>) next to Wi-Fi, then select Show available networks.If a network you expect to see appears in the list, select it, then select Connect. Open Wi-Fi settings
View printer queue in Windows - Microsoft Support
Select your printer from the list and then select Open queue to see a list of what's printing and the upcoming print order.
Design the layout and format of a PivotTable - Microsoft Support
To make substantial layout changes to a PivotTable or its various fields, you can use one of three forms: Compact form displays items from different row area fields in one column and uses indentation to distinguish between the items from different fields.Row labels take up less space in compact form, which leaves more room for numeric data.
Applies To: Excel for Microsoft 365, Excel for the web, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2016, Excel 2013
Find out how much storage your PC has - Microsoft Support
Learn how to check your PC's storage capacity and manage it effectively with Microsoft Support's guidance.