How to Separate First and Last Name from Full Name
Do you know how to separate the first name and last name from the full name in Excel? There are multiple ways using which you… Read Article
How to Save All Charts in Excel into Separate Images
Have you ever worked with Charts in Excel? If yes, then have you ever faced the requirement to save all the charts in various excel… Read Article
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