Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.
Transpose (rotate) data from rows to columns or vice versa
Note: If your data is in an Excel table, the Transpose feature isn't available.You can convert the table to a range first, or you can use the TRANSPOSE function to rotate the rows and columns.
Applies To: Excel for Microsoft 365, Excel for the web, Excel 2021, Excel 2019, Excel 2016
About the Microsoft Support and Recovery Assistant
Scenario. Description. Recommended Solution. Add Teams meeting add-in for Outlook. Helps fix the issue where teams meeting add-in is missing or is not loaded, preventing you from creating teams meeting from Outlook.
Applies To: Outlook for Microsoft 365, Office 2021, Office 2019, Office 2016, Microsoft 365 for home, Microsoft 365 admin
Organize your ideas with Collections in Microsoft Edge
Collections in Microsoft Edge helps you keep track of your ideas on the web, whether you're shopping, planning a trip, collecting notes for research or lesson plans, or just want to pick up where you left off the last time you were browsing the internet.
Filter by using advanced criteria - Microsoft Support
Using the equal sign to type text or a value. Because the equal sign (=) is used to indicate a formula when you type text or a value in a cell, Excel evaluates what you type; however, this may cause unexpected filter results.To indicate an equality comparison operator for either text or a value, type the criteria as a string expression in the appropriate cell in the criteria range:
Applies To: Excel for Microsoft 365, Excel 2021, Excel 2019, Excel 2016
Fix File Explorer if it won't open or start - Microsoft Support
Learn how to troubleshoot File Explorer problems in Windows. To open File Explorer in Windows 10, select its icon on the taskbar, press the Windows logo key + E on your keyboard, or select Start > Documents (directly beneath your user icon).. Here are some things to try if File Explorer won't open.
SUBTOTAL function - Microsoft Support
This article describes the formula syntax and usage of the SUBTOTAL function in Microsoft Excel.. Description. Returns a subtotal in a list or database. It is generally easier to create a list with subtotals by using the Subtotal command in the Outline group on the Data tab in the Excel desktop application. Once the subtotal list is created, you can modify it by editing the SUBTOTAL function.
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
COUNT function - Microsoft Support
The COUNT function counts the number of cells that contain numbers, and counts numbers within the list of arguments. Use the COUNT function to get the number of entries in a number field that is in a range or array of numbers. For example, you can enter the following formula to count the numbers in the range A1:A20: =COUNT(A1:A20).In this example, if five of the cells in the range contain ...
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
Reactivating Windows after a hardware change - Microsoft Support
In Windows 11, it is essential that you link your Microsoft account with the Windows 11 digital license on your device. Linking your Microsoft account with your digital license allows you to reactivate Windows using the Activation troubleshooter whenever you make a significant hardware change.
Find your IP address in Windows - Microsoft Support
Get info on how to find your IP address in Windows. Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.
Look up values with VLOOKUP, INDEX, or MATCH - Microsoft Support
Here's an example of how to use VLOOKUP. =VLOOKUP(B2,C2:E7,3,TRUE) In this example, B2 is the first argument—an element of data that the function needs to work.For VLOOKUP, this first argument is the value that you want to find.
Applies To: Excel for Microsoft 365, Excel for the web, Excel 2021, Excel 2019, Excel 2016