How to create check boxes in Excel (Tick boxes)

How to create check boxes in Excel (Tick boxes)

A check box, also referred to as a tick box, is a form control input which you click to select or deselect a given option. If you click on an empty check box, a checkmark is added into the small box. The check box control works like a switch or toggle. Thus, if you...
How to create a dropdown list in Excel

How to create a dropdown list in Excel

The dropdowns are great tools for either increasing the end-user experience or limiting the end-user with specific options to select from. You can use Data Validation Lists to create your own dropdowns in Excel. In this guide, we are going to show you how to create a...
How to create a bell curve in Excel

How to create a bell curve in Excel

A bell curve, also known as normal distribution, is the most common type of distribution for a variable. It is accepted as a distribution that occurs naturally in many situations. In a bell curve, the highest point of the arc defines the mean, which is the highest...
How to lock cells in Excel

How to lock cells in Excel

By locking certain cells in your workbook, you can guide your users into other sections of your workbook and essentially convey the idea that the locked cells are to be treated as outputs, and all others inputs. This is especially useful in applications where you want...
How to change text orientation in Excel

How to change text orientation in Excel

You can easily increase the column width to fit more contents into a smaller area. However, increasing the column width means that you’re going to be able to use fewer columns. Changing the alignment of the text can help overcome these limitations and allow you...
How to hide zeros in Excel

How to hide zeros in Excel

Hiding zero (0) values in Excel can be especially helpful for de-cluttering your workbooks and in most cases, make them easier to read. In this guide, we’re going to show you how to hide zeros in Excel worksheets, following three different methods. How to Hide Zeros...