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 select every other row in Excel using manual selection, helper column & filter, and VBA methods.| 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 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
Have you ever wondered if there's an easy way to swap cells in Excel?| 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 remove dotted lines in Excel worksheets. This guide covers removing page break lines, cell border lines, and gridlines in spreadsheets.| 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 to paste data into filtered columns without affecting hidden cells in Excel (using a simple formula trick and some simple VBA code)| Spreadsheet Planet