Learn how to Paste without Formatting in Excel using keyboard shortcuts for Windows and Mac. Also includes a less-known Control trick| Spreadsheet Planet
Learn how to filter data in Excel based on cell color using different methods such as the filter option, right-click menu, custom sort, and VBA script.| 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 remove formulas but keep the data in Excel using a simple shortcut, the paste special technique or a simple VBA code.| Spreadsheet Planet
Learn how to remove apostrophes in Excel with three fool-proof methods (using Text to columns, a multiplication trick, and simple VBA code)| 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 to paste data into filtered columns without affecting hidden cells in Excel (using a simple formula trick and some simple VBA code)| 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