There are times when you might want to control what data the user can enter to a cell. For example , you want the user to enter only a numeric value that is greater than 75. How to limit entries to n...

Do you want to retreive the created time and the last modified time of your Excel workbook and display it in the excel sheet ? Here’s a code snippet demonstrating how you can display them in th...

There are times when you have to NOT just create or insert a drop-down list in Microsoft Excel sheet but also color code the value so that when the user selects a value from the drop-down list , the ...

This blog post will explain how you can auto populate the cell when you select a value from drop-down list in Microsoft Excel 2016. The previous blog post demonstrated how you can create drop-down li...

Creating a drop-down list in a excel sheet is one of the most frequently used operation in Microsoft Excel and this blog post will demonstrate how you can insert one to a excel sheet in Microsoft Exc...