Tips, Tricks, and Answers

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

Easily Dividing Values by a Set Amount. When working with large numbers, you may need a way to quickly divide a range of those numbers by a specific value. Here's the absolute fastest way to make the change.

Making Blanket Changes to Values. If you need to update a bunch of values in a worksheet by a standard amount, you can use the Paste Special feature of Excel to make the change easy. This tip illustrates how easy it really is.