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

How to Remove Personal Information from a Workbook Using VBA in Microsoft Excel 2010

In this article, you will learn how to remove personal information from a workbook. When you save a workbook, some of your personal information suc...

Saving A Customized Workbook As A Template In Microsoft Excel 2010

In this article, we will learn how to save a customized workbook as a template in Microsoft Excel 2010. To save a customized workbook as a template...

Changing The Default Cell Comment FormatIn Microsoft Excel 2010

In this article, we will learn how to change the default cell comment format in Microsoft Excel 2010.   To change the default cell comment ...

Removing Personal Information from a Workbook in Microsoft Excel 2010

Why is it important to remove personal information from a workbook? When you do not want to expose your personal details while posting a question w...

Format all worksheets of a workbook in a Single Go

It often requires to do formatting in a worksheet and then apply the same in different worksheets of the workbook which is very time consuming activit...

How to Unhide multiple columns at once in Excel

In this article, we will learn How to Unhide multiple columns at once in Excel. Scenario: Rows and Columns combine to make a sheet in excel....

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.