Table of Contents
Create one or more print areas
View a print area
Add cells to an existing print area
Clear a print area
In most cases Excel spreesheets are very big and complex. When you want to print…
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
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…