More Information

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

Tips, Tricks, and Answers

The following articles are available for this 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.