Shortcut To Toggle Between Absolute and Relative References in Excel

Use F4 key on window to toggle between Relative and Absolute References.Just select the range and press F4. If you press once: $A$1 If you press...

Relative and Absolute Reference in Excel

While working or learning Excel, you’ve must heard of Relative and Absolute referencing of cells and ranges. Absolute referencing is also called l...

Copy visible cells only

In Excel, when we copy anything it copies both hidden and visible cells. In this article, we’ll learn how to copy visible cells only.    ...

Function Keys Shortcut In Microsoft Excel

In this article you’ll learn about: Significance of Function keys in MS-Excel Function keys in combination with modifier (Ctrl, Alt, Shift) ...

Extract Image using Index and Match

In this article, we will learn how to retrieve picture, using Index & Match functions. We have following name of the pictures in column A &...

Data Validity to Prevent Space before Text in Microsoft Excel

In excel if you every come across a scenario in which you do not want the other user from entering space before text then this article is for you. ...

Scatter Chart in Microsoft Excel

In this article, we will learn how to make Scatter graph in Microsoft Excel. Scatter Chart is used to show the relationship between sets of value a...

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