Learn why dates in Excel show as hashtags and how to fix it. Column width, negative numbers, date values outside Excel's range. are common causes| Spreadsheet Planet
Learn how to convert serial numbers to date in Excel using TEXT function, number formatting, and VBA macro codes.| Spreadsheet Planet
Learn how to add a specific number of days to a date in Excel using simple formulas and the DATE() function. Easily calculate future dates for delivery, payroll, and more.| 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
In this tutorial, I will show you two ways to find merged cells in Excel (using Find and Replace and VBA). Once found, you can unmerge these or highlight these| Spreadsheet Planet
Learn how to UnSort your dataset in Excel and revert back to the original data using a temporary column or creating a backup copy.| Spreadsheet Planet
Learn how to quickly unmerge all cells in Excel using the Merge and Center button, Find and Replace, VBA script, and how to copy original values to unmerged cells.| 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 flip data in Excel - columns, rows, and tables using different methods such as helper columns, formulas, and VBA.| Spreadsheet Planet