Learn how to apply the Accounting Number Format in Excel using three different methods. Also understand the differences from the Currency format| Spreadsheet Planet
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 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 select multiple rows in Excel, whether they are contiguous or non-contiguous, using simple and quick methods.| 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 easily sort data by date in Excel using simple steps. From sorting single columns to multiple columns, and troubleshooting common issues, this tutorial has got you covered.| 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 leading zeros in Excel using different methods - custom number format, text format, and formulas,. Also, remove a fixed number of zeros with ease.| Spreadsheet Planet
Learn how to remove the dollar sign in Excel using different methods such as formatting, formulas, Find and Replace, and the VALUE function.| Spreadsheet Planet
Learn how to count negative numbers in Excel using COUNTIF formulas and a simple VBA macro code.| 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 split one column into multiple columns in Excel using the 'Text to Columns' feature (step-by-step instructions)| 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