Taking Time of Day into Account in a Formula

At the heart of Excel is the ability to create formulas to calculate a desired result. You may have a need to base a calculation on the time of day. This tip provides an example of how easy it is to incorporate time-based considerations into your formulas.

Read this tip »

(Thanks to Murray Belchamber, Steve Aprahamian, Ryszard Raciborski, Paul Hignett, Bob Farey, Brian Dorey, Fred van der Meulen, Michael Avidan (MVP), Alan Cannon, Craig Korfanta, Elliot Penna, James Woolley, Nick Jolly, Kent Daniel, Jeff Paliwoda, Tom Reeves, Fred Potter, Dick Downey, Sundararajan Chandrasekhar, John Vander Linden, Paul Harvitz, Rick Harris, Yvan Loranger, and James Wolz for contributing to this tip.)

Changing the Color of a Cell Border

Excel provides a variety of tools you can use to make your data look more presentable on the screen and on a printout. Here's how to change the color of the borders you may add to your cells.

Read this tip »

Enhance Your Excel Skills with Macros

Macros are a great way to increase your productivity with Excel by making the program work the way you want it to work. Discover the true power behind macros; ExcelTips: The Macros puts almost 800 pages of macro-focused information at your fingertips. Discover more...

Changing the Default Paste Mode

Don't like the way that Excel pastes when you press CTRL+V? Here are some ways that you can modify the normal paste mode used by Excel.

Read this tip »

Removing a Directory

Macros allow you to perform all sorts of file-related operations. One such operation allows you to delete a directory. This tip shows how easy this can be.

Read this tip »

This section is for those having problems making Excel behave. If Excel is giving you fits, feel free to submit your own Help Wanted question.

If you have a solution for the problems below, click the link after the problem to send us your answer. (All responses become the sole property of Sharon Parq Associates, Inc., and can be used in any way deemed appropriate.) If your response is used in a future issue, you will be credited for your contribution to the answer.

Summing the Largest Values

I have a list of transactions in a worksheet. Column G contains the amount for each transaction. These transactions can be positive or negative. I need to derive two sums from the transaction list: the seven largest positive transactions and the seven largest negative transactions. I just need the sums, not any other information about the transactions.
—Paul Harris (provide an answer for this Help Wanted question)