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 ...

Entered Values are Divided by 100

Here are a few different things that could be causing the problem. The most likely is that Excel is configured so it automatically places a decimal po...

Add Combo Box to a Sheet in Microsoft Excel 2010

Excel Combo box is used to create a drop down list of selected items as per the choices required. There are 2 types of Combo boxes - 1st is a Combo Bo...

Problem: Unnecessary Empty Characters in Cells

To remove empty characters, use the Trim function. The Trim function is in the Text category in the Insert Function dialog box. To insert the Tr...

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