Excel 2016

Table of Contents Create one or more print areas View a print area Add cells to an existing print area Clear a print area Related Articles In most cases Excel spreesheets are very big and complex. When you want to print them,…

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…