Using =VLOOKUP() Function for Partial Match in Excel
Many times you have excel data where you want to do a partial match of the data. To perform a partial match of data in… Read Article
How to use Excel Fill Handle Tool
You might have heard about an amazing Excel Fill Handle Tool? Do you know what exactly is this Excel Fill Handle Tool? What benefit does… Read Article
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