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...

In one of the previous blog posts , we demonstrated how you can use the function RANDBETWEEN in Microsoft Excel to generate random number in Excel. In this blog post, let's have a look at genera...