Excel Blog - Page 2
Page 2 of Excel tutorials and guides.
Articles
- Transpose Data in Excel: Learn how to transpose data in Excel using Paste Special, the TRANSPOSE function, dynamic arrays, and Power Query for repeatable workflows.
- Remove Blank Rows in Excel: Learn safe ways to remove blank rows in Excel using filters, Go To Special, sorting, and checks that avoid deleting valid partial records.
- Sort by Date in Excel: Learn how to sort dates in Excel, fix dates stored as text, sort by month, newest to oldest, oldest to newest, and custom date groups.
- Filter by Color in Excel: Learn how to filter by cell color, font color, and conditional formatting color in Excel reports and cleanup workflows.
- Wrap Text in Excel: Complete Guide: Learn how to wrap text in Excel, add line breaks, fix row height, align text, and make long labels readable in reports.
- Merge Cells in Excel: When to Use It and Avoid It: Learn how to merge cells in Excel, when merged cells are useful, why they can break sorting and filtering, and better alternatives.
- Compare Two Columns in Excel: Compare two columns in Excel to find matches, differences, missing values, duplicates, and lookup mismatches using formulas and formatting.
Recommended Excel resources
- Browse the complete Excel functions directory to find syntax, examples, common errors, and related formulas for every major function.
- Use the formula problem guides when a workbook returns #N/A, #VALUE!, #SPILL!, wrong totals, or formulas that do not update as expected.
- Compare similar Excel functions before choosing a formula, especially for lookup, conditional aggregation, text cleanup, and dynamic array tasks.