Having trouble locating the cells in your worksheet that contain conditional formatting? Excel will select the cells for you, all you have to do is the following…

By default, Excel creates three worksheets in each new workbook that you create. If you prefer to reduce or increase this behavior to better meet your needs, follow these instructions…

Removing duplicates from a spreadsheet can be a timely task, fortunately Excel can do this for you. Here’s how…

Using conditional formatting, you can easily highlight duplicate values in your spreadsheet. This will make it easier to identify the duplicates so that you can remove them. To do this…

While the new Ribbon interface is a great feature of Excel 2007, it does take a little time to get used to it. In some cases, you will have to search around a bit to find some of the commonly used commands. This should give you a headstart in getting up and running . . [...]

Previous versions of Excel required you to utilize a dialog box to add or modify the header and footer. With the new version of Excel, it is much simpler to add a header and/or footer to your worksheet.

By default, Excel automatically updates calculations when you alter data cells used in that calculation. If you have a very large worksheet, the updating can be slow. To disable automatic recalculation, follow this tech recipe:

In Excel, you can change your data’s appearance based on its value. For example, you could change the color of negative balances in your worksheet to be red while positive numbers are black. To do this, follow the steps in this Tech-Recipe.

You can set up a validation rule to make sure the data entered into a cell meets certain criteria. The Data Validation dialog box can be used to define the type of data that Excel should allow in the cell and to set the conditions data must meet to be accepted in the cell.

Instead of the normal black gridlines in your Excel spreadsheet, you can change them to be any color your choose. To do this: