Learn how to quickly select every other cell in Excel using three ingenious tricks (using Go To special, Filter, and a VBA macro code)| Spreadsheet Planet
Learn how to select multiple rows in Excel, whether they are contiguous or non-contiguous, using simple and quick methods.| Spreadsheet Planet
In this tutorial, I will show you two ways to find merged cells in Excel (using Find and Replace and VBA). Once found, you can unmerge these or highlight these| 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 easily delete sheets in Excel using VBA with just a few lines of code. Save time and effort with this simple automation technique.| 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 how to quickly rearrange rows in Excel using different methods like shift key and mouse, cut copy method, insert row and cut/copy method, and sorting.| Spreadsheet Planet
Learn how to select rows with specific text in Excel using a simple VBA code or a simple Data Filters trick.| 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
Learn how to select alternate columns in Excel using traditional and VBA methods, and how to highlight, delete, or select every Nth column.| Spreadsheet Planet
Learn how to hide columns in Excel based on cell values using VBA macros. This tutorial provides step-by-step instructions for both real-time and macro-executed hiding.| Spreadsheet Planet