How to Create a Dependent Drop-Down list in Excel
Do you know how to create a dependent drop-down list in an Excel worksheet? At the end of this blog, you would be able to… Read Article
Tips and Tricks
This category is dedicated to covering all the tips and tricks of Excel.
How to Sort by Last Name in Excel
In this blog, we would learn how to sort data be the last name. Many a time, you have an excel worksheet with names of… Read Article
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 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
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 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