- Knowledge Base
- Applications & Software
- Microsoft 365
- Excel
If you have a worksheet with data in columns that you need to rotate to rearrange it in rows, use the Transpose feature. With it, you can quickly switch data from columns to rows, or vice versa.
- Knowledge Base
- Applications & Software
- Microsoft 365
- Excel
If you receive information in multiple sheets or workbooks that you want to summarize, the Consolidate command can help you pull data together onto one sheet.
- Knowledge Base
- Applications & Software
- Microsoft 365
- Excel
Excel makes it easy to crunch numbers. With Excel, you can streamline data entry with AutoFill. Then, get chart recommendations based on your data, and create them with one click. Or easily spot trends and patterns with data bars, color coding, and icons.