Cell references in Excel are very important. In this article we will learn difference between absolute cell reference & relative cell reference i...
In this article, we will learn how we can define a range name in Microsoft Excel 2010. There are two techniques to define a range name. Let’s tak...
In this article, we will learn how to paste the cell values by using the Paste Special function or how we can write the VBA code in Microsoft Excel 20...
In this article we are going to learn how to remove blank rows in Excel? To delete empty rows, we can use ‘Sort’ option and ‘Go To Special’...
Formulas can be long and often take up several rows. Formulas can be made shorter by either using a range’s defined Names for the references or shor...
If you are interested in seeing the calculation of numbers quickly without using formulas, you can see the results in status bar. To see calculations ...
In this article we will learn how to return text up to the second space in Microsoft Excel. For this, we will be using the combination of Exc...
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.