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

Spider Chart / Radar Chart in Microsoft Excel 2010

In this article, we will learn how to prepare Spider Chart / Radar Chart in Microsoft Excel 2010. Spider Chart is a graphical method to show the comp...

Change the Default Number of Sheets in a New Workbook in Microsoft Excel

In this article, we will learn how we can change the default number of sheets in a new workbook in Microsoft Excel. To change the default number of...

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.