Excel Tips

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.

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.