In this article, I’ll show how you can count if a cell contains text in Excel. I’ll show you to count the number of cells that contain texts, as well as the ...

In this article, I’ll show you how you can delete multiple rows in Excel with VBA. The article will combine deleting multiple rows of a selected range, rows ...

Many a time while working in Excel, we have to deal with the Excel IF between multiple ranges. Today I’ll show you can work with the IF function between ...

Today I’ll show you how can count rows with VBA in Excel from any data set. I’ll show you how can count rows from a specific range, from a selected range, by ...

We often need to remove the first character from a cell or a range of cells while working in Excel. Today I’ll show you how you can remove the first character ...

While working in Excel, you can use a Macro to delete rows based on criteria. Today I’ll show you how you can use a Macro to delete rows based on criteria in ...

Today I’ll show you how you can use VBA to delete the empty rows in Excel from your data set. Download Practice Workbook Delete Empty Rows in ...

A dynamic named range is a pretty important and helpful tool that we often have to create while working in Excel. Today I’ll show you how you can create a ...

While working in Excel, we sometimes have to delete multiple rows from a data set with a given condition. Today I’ll show you how to delete multiple rows based ...

While working in Excel, we often have to enter the current date and time in a cell for various purposes and auto-update them. Today I’ll show you how you can ...

One of the most important and widely used activities that we have to accomplish while working in Excel is to transpose a data set. Today I’ll show you how you ...

One of the most important and widely used tasks that we have to accomplish while working in Excel is to merge cells vertically without losing any data. Today ...

We often have to copy one or multiple sheets from one workbook to a new workbook while working in Excel. Today I’ll show you how you can copy multiple sheets ...

One of the frequently used tasks that we perform in Excel is to insert multiple rows after every other row. Today I will show in this article how you can ...

We often have to insert a blank row after every nth row in our data set while working in Excel. Today I’ll show you how to insert a blank row after every nth ...