How to Get Last Value In Column

In this article, we will learn how to retrieve cell address of a lookup value. There will be times when you would want to get address of cell from ...

Excel STANDARDIZE Function

In this article, we will learn about how to use the STANDARDIZE function in Excel. To get the normalised score (Z-score) of the value in the data...

How to correct a #NUM! Error

In this article, we will learn about How to correct #NUM! Error in Excel. Excel generates error with a name starting with number sign(#) as soon as yo...

Shows formula but not result in Excel

In this article, we will learn about how to view formulas in the cell in Excel. Excel performs a function in a cell when using equals to sign (=). ...

How to disable Scroll Lock in Excel

In this article, we will learn about how to disable Scroll Lock in Excel. Arrow keys in excel move your cell up, down, Left & Right. But this f...

How To Unmerge Cells In Excel

Sometimes you get data from your colleague or from a web server that has merged cell for the sake of formatting or any other reason. Now when you try ...

How to Merge Two Columns Without Losing Data in Excel

Since you’re here, you’ve must tried to merge and center two cells to get them combined, but to your surprise, you only got the data in the left c...

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