Excel 2016

In Office 2007, Microsoft introduced new extensions: xlsx, docx, ppts etc. which are no longer binaries but based on Office Open XML. Since then, they are also the default format for saving files. However, if you still need to save new…

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…

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…

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…

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…