If you are an Excel worksheet that contains address information, you may want to convert nine-digit ZIP Codes to their five-digit equivalent.

Anything you do in Excel that is of a repetitive nature is a good candidate for a macro.

You may want to print multiple pages of your Excel worksheet on a single piece of paper.

To ensure that only certain data can be entered in the cell, follow these steps:

Step by step instructions for how to create CSV files that are often used for transferring simple data from one program to another.

This list allows users to select the cell and then select from a list of pre-defined values for that cell. Once the user makes a selection and moves to a different cell, the arrow for the drop-down list disappears.

The sorting capabilities of Excel are quite handy, and quite powerful…but sometimes subject to corruption.

Give your Microsoft Excel graphs a more professional look by simply smoothing out the curves Excel uses at each data point.

Excel includes a control that allows you to specify how you want it to interpret what percentage you enter.

There is a very cool way, apparently not well known, of adding ‘active’ or ‘live’ titles and other text to charts.