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 select every other row in Excel using manual selection, helper column & filter, and VBA methods.| Spreadsheet Planet
Learn how to highlight every other row in Excel using Conditional Formatting, Banded Rows Table Styles, and VBA. Make your data more readable and easier on the eyes with these simple techniques.| 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 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 select rows with specific text in Excel using a simple VBA code or a simple Data Filters trick.| 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 delete filtered rows in Excel using filters and VBA. Also, find out how to delete hidden rows without VBA.| Spreadsheet Planet
Learn 4 easy ways to add text to the beginning or end of all cells in Excel using ampersand, CONCATENATE, Flash Fill, and VBA.| Spreadsheet Planet