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

Cell Function Returns Sheet Name, Workbook Name and Path in Microsoft Excel 2010

We have a useful function in excel called as the CELL function which can be modified to return the sheet name, workbook name and the file path.  In t...

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 Youtube