Merging cells in an Excel spreadsheet is extremely useful. By merging cells, you can greatly enhance the look and feel of a spreadsheet.

Unknown to many excel users, you can easily set up check boxes in Excel. You can use these check boxes to total a list of data by selecting various boxes.

The Hide Column feature in Excel is a very easy to use and handy trick. From a personal standpoint, I find myself hiding columns quite frequenly in order to clean up the spreadsheet.

Quick Overview

The AutoSum Function is by far one of the most useful features in all of Excel. Just about every spreadsheet can benefit from incorporating the AutoSum function.

Lets Begin

To begin, let’s start with a list of data we are looking to sum.

The SUMIF function adds cells specified in range by a certain condition or criteria.