Excel 2016

This article will show you how to add/create a dropdown list control in Excel so that the user can select only predefined value from custom list. What we want to accomplish We want the user to be able to select a color in cell B1 from the…
Read More...

Lets say that you have a column with values, and you need to find out what distinct/unique values are in there. Note: Goal is not see how many are there but to find an actual list of those values. This is similar to SQL's SELECT…
Read More...

By default, Excel takes units of measurement from the system settings. Sometimes, however, these settings are not the ones we want to use in Excel. The good news is that these units can be changed in Excel settings without having to…
Read More...

There is nothing worse than those the little annoying problems that pop up just when we have an important job to do. Probably one of the worst of them is the missing formula bar. When it is gone, we can not see or write any formulas. Most…
Read More...

There are two functions which you can use to get current Date and Time in Excel: =TODAY() and =NOW(). You can use these functions as part of a text string by putting them into TEXT function with formatting string. It’s important to…
Read More...