In this article, I will tell you how to remove duplicate rows in excel with two methods. The first method is using the excel advanced filter feature, this method can reserve the original datasets. The second method is to use excel’s remove duplicates menu, this method will remove the duplicate rows permanently.
This article will tell you how to use the VBA sub-procedure to catch the worksheet change event and then insert the current date time in the next adjacent cell. It will also tell you how to use VBA to create an excel function and call the function to insert the current date and time in …
In the previous article, I told you how to insert the date & time in excel using excel functions or shortcuts manually. In this article, I will tell you how to insert the date & time in one excel cell automatically when you input or update data in another excel cell.
When you input a formula in an excel cell, sometimes you may encounter the excel circular reference error. The error message is there are one or more circular references where a formula refers to its own cell either directly or indirectly. This article will tell you how to fix this error on Excel for Windows …
In this article, I will tell you how to insert the current date and time in excel using the excel functions or shortcuts.
In this article, I will tell you how to insert/delete a cell, row, or column in an excel worksheet. It will also tell you how to remove the cell content without moving the cell position.
When you input a number in an excel cell and if the number needs to start with 0, you will find excel will remove all the zeros at the beginning of the number. In this article, I will tell you how to put 0 in excel in front of numbers with several methods.
This article will tell you how to add an empty option in the excel data validation drop-down list. There are 2 methods to implement this, I will show them with examples.
The excel SUM function can calculate the summary of number values in a cell range. But when you add a new number cell before or after the cell range, the SUM function can not add the dynamically added number in the result. This article will tell you how to sum dynamic range in excel.
The excel OFFSET function can be used to get the reference to a cell or cell range from the starting point ( cell ). It is very useful when you use it correctly. This article will tell you how to use it with some examples.