How to Add Zero in Front of Number in Excel
Many a time, you may have a long list of numbers in Excel and you may wish to add zero before the number. Do you… Read Article
How to Remove the First Character from cells in Excel
Many a time, you may have a dataset in excel wherein there is one additional character at the beginning of the dataset and you wish… Read Article
How to Highlight Every Alternate Row in Excel
Have you ever faced with a need to make your excel dataset table banded? By branded table, I mean that every second, third, fourth, etc.… Read Article
How to Wrap Text in Excel Cell
Do you know how to wrap a text in an excel cell? What is the purpose of Wrap text function in excel?… Read Article
How to Move Row or Column in Excel
Have you ever wondered how we can move a row or a column in excel quickly without using copy and paste functionality?
Let us take… Read Article
How to Remove Middle Name from Full Name in Excel
Do you know how to remove the middle name from the full name? In this blog, we would learn different ways that can be used… Read Article
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