Formulas

Tips, Tricks, and Answers

The following articles are available for the 'Formulas' topic. Click the article's title (shown in bold) to see the associated article.

Accessing the Formula Bar without the Mouse
Hate to take your hands off the keyboard while working on a worksheet? Here's one way to activate the Formula bar without the need of using the mouse.

Adding Due Date Alerts
As a due date approaches, you might want Excel to let you know. It's easy to add any of several types of alerts, as illustrated in this tip.

Common Formulas in Excel
Got some formulas you slaved over and want to use in lots of workbooks? This tip presents some helpful ideas on how you can save those formulas for easy recall later.

Creating a List of Worksheet Formulas
The formulas in your worksheet can be displayed (instead of formula results) by a simple configuration change. You can then easily make a copy of those formulas for documentation or analysis by applying the ideas in this tip.

Highlighting Cells Containing Formulas
One of the nifty purposes to which you can put conditional formatting is highlighting cells with different types of contents. This tip explains how you can use the tool to highlight cells that contain formulas.

More Information

The following are additional topics related to the subject of 'Formulas'. A bracketed number after the topic indicates how many articles are related to that subject.