Calculating just the worksheet NOT whole workbook

If you have huge number of complex formulas in your workbook and it takes long time for workbook to calculate the formulas everytime you enter a new f...

Monthly expense report for colleagues

Dear friends, Here is a simple, most useful application for colleagues. Find an example with the attached file. Don't confuse with the names noted ...

Listing/Renaming Files in a folder from excel

1. Go to the Custom Tools Tab 2. Click the "Get File Names" Button and select the folder containing the files 3. Enter the desired new file names in...

Excel Calendar + Memo

This is something I came up with around 14 months ago for my company. Attached is the modified version for general usage. In short, this excel con...

let excel talk to you CATEGORY - Excel Tools VERSIO

heres a little known trick in excel 2007> options/customise/all commands scroll down and add speak cells to your quick access toolbar now select...

Stock Quote fetching

If you wish Excel to fetch stock quote, follow below steps:-   1.Before you proceed, make sure that Smart Tags are turned on @ http://suppo...

Excel Files Back-Up

Do you have important Excel files that would create nothing short of chaos and disaster for you if you were to lose those files? Now I'm sure that ...

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube