In this article, we will learn How to validate date entries which contain specific year, specific month or specific date using data validation in ...
In this article, we will learn How to Get the Path of Current Worksheet in Excel. CELL function in Excel Cell function in Excel ge...
In this article we will learn how to create dynamic list? In Excel, we can limit the user to input values in a cell to a drop down list, using Data V...
In this article, we will learn How to Freeze Panes in Microsoft Excel. Freeze panes: - We use this option to freeze a portion of sheet to keep ...
In this article, we will learn how we can delete blank rows or rows that contain blank rows in Microsoft Excel 2010. Go To Special: - This option i...
In this article, we will learn the random number generator in Microsoft Excel. To generate the random number, we will use the “RAND” and “RA...
In this article, we will learn How to Square Root in Excel. SQRT function is used when we need to find the square root of a number in Excel. The...
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.
