Learn how to count filtered rows in Excel using simple methods like the SUBTOTAL and AGGREGATE functions. Save time and avoid headaches with these nifty tricks!| Spreadsheet Planet
Learn how to select visible cells only in Excel using keyboard shortcuts, Go To Special dialog box, and Quick Access Toolbar. Copy and paste only the visible cells to exclude hidden ones.| Spreadsheet Planet
Learn how to Paste without Formatting in Excel using keyboard shortcuts for Windows and Mac. Also includes a less-known Control trick| Spreadsheet Planet
Learn how to filter data in Excel based on cell color using different methods such as the filter option, right-click menu, custom sort, and VBA script.| Spreadsheet Planet
Learn how to clear filters in Excel with simple keyboard shortcuts or using the ribbon option + learn how to identify if filters have been applied| Spreadsheet Planet
Learn how to filter data dynamically as you type in Excel using the FILTER function in Office 365 ((No VBA needed)) or using a simple VBA code| Spreadsheet Planet
Learn how to quickly delete hidden rows and columns in Excel using the Inspect Document feature or VBA code (without manually doing it)| Spreadsheet Planet
Learn three easy ways to quickly convert positive numbers to negative in Excel - using Paste Special, formulas, and VBA| Spreadsheet Planet
Learn how to hide rows in Excel based on specific cell values using filters and VBA. This tutorial provides step-by-step instructions & code examples| Spreadsheet Planet
If you work with Excel on a regular basis, there's a good chance that you've had to copy and paste data at some point.| Spreadsheet Planet
Learn how to compare two cells in Excel using formulas for an exact or partial match, including case sensitivity. Also convers how to compare numeric cells| Spreadsheet Planet
Learn how to delete filtered rows in Excel using filters and VBA. Also, find out how to delete hidden rows without VBA.| Spreadsheet Planet
Learn how to compare two columns in Excel using VLOOKUP. Find matches and differences in data, and highlight rows with matching or different values.| Spreadsheet Planet