Drop-down lists in Excel let you create a list of valid choices that you can select for a given field. We'll show you how to use tables, named ranges, formulas, data validation, and table styles.

Learn how you can make use of Name Box in Excel. The purpose of Excel Name Box is to help reduce the time taken while working with columns, cells, rows & ranges.

The Box and Whisker Chart shows the distribution of data into quartiles. Learn how to create a Box and Whisker Chart in Excel properly.

How to Multiply Boxes in Excel. Microsoft Office Excel includes a wealth of function options when entering data in to your spreadsheet. For instance, if you want to multiply a pair of cells or ...

How to Convert True-False to Check Boxes in Excel. Microsoft Excel's form controls can turn the Boolean options of a true-false choice into a clickable data-entry option. If you create ...