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 5 simple ways to select non-adjacent cells in Excel, including using keyboard and mouse maneuvers, the Name Box, Find and Replace, and the Go To feature.| Spreadsheet Planet
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 quickly unhide all rows in Excel using VBA. This tutorial provides VBA code to unhide rows in a specific range or all worksheets| 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 five methods to copy row height in Excel, including using the ribbon, format painter, paste special, Kutools add-in, and keyboard shortcuts.| 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