Calendar in Excel

Sometime we love to have calendar in Excel. You can display a calendar in a excel sheet and enter date in a cell by selecting the appropriate date. F...

ALT key to show Dictionary

Do you know you can use Dictionary in Excel..!! If you have any word in Excel Sheet for which you need to know the meaning / synonyms etc, you do n...

Name Box for quick navigation and range selection

If you wish to navigate quickly on a excel sheet or to select a range, you can use Name box which is there on above side of column A (see attached ima...

Calculate selected formula portion

This is very useful tip to calculate the part formula portion of a long formula. Suppose you have a long formula and you just wish to know the part...

Camera Tool

Tip Tile:- Camera Tool Camera tool is very useful tool when you want to display (mirror) the selected data to any other location on Excel.  It tak...

Repeat your last Command / Action

f you often repeat things in Excel and do not want to have a macro (VBA), you can use the smart key "F4". The "F4" key repeats your last command / ...

Auto Calculator feature in Excel

Excel 2010 has a quick Auto Calculator feature which can be found in bottom right corner of Excel window. Usage:- Suppose you need to find the ...

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