How to Select Cells Containing Data Validation
Do you know how to find and select the cells in an excel worksheet that contain data validation? In this blog we would learn how… Read Article
How to Create a Dynamic Drop Down List in Excel
Do you know that you can even define a dynamic drop-down list in Excel? The excel data validation rule along with =OFFSET() formula would help… Read Article
How to Hide or Unhide Row or Column in Excel
This is a quick guide on how to hide and unhide a row or column in Excel. In this blog, you will unlock several ways… Read Article
How to Remove Leading Spaces in Excel
Has it happened with you that you export some data from some system and there are unwanted spaces before a number, text in Excel? Removing… Read Article