Changing an absolute cell reference to a relative reference in Microsoft Excel

Cell references in Excel are very important. In this article we will learn difference between absolute cell reference & relative cell reference i...

Defining a Range Name in Microsoft Excel 2010

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

Pasting Values in Microsoft Excel 2010

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

Excel Delete Blank Rows

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

Entering Formulas More Quickly by Shortening Sheet Names

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

Seeing Calculation Results Immediately

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

Return text up to the second space in Microsoft Excel

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

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