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
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 move rows to another sheet in Excel based on a specific cell value using filters trick and simple VBA macro codes.| 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 copy formatting in Excel using Format Painter, Paste Special, Fill Handle, and more. Easily apply formatting to single or multiple cells with these simple methods.| 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 select alternate columns in Excel using traditional and VBA methods, and how to highlight, delete, or select every Nth column.| Spreadsheet Planet