How To Automatically Hide Sheet in Microsoft Excel 2010

In this article, you will learn how to hide sheet automatically when the sheet is not in use.   Let us understand with an example: Consider ...

How to Add Rupee Symbol In Microsoft Excel 2010

In this article, you will learn on to show Indian Rupee symbol in chart.   Let us take an example to understand: We have Sales Report that c...

How to Add Error Bars to a Line Chart in Microsoft Excel

In this article, you will learn how to add error bars. Error bars is a great feature in Excel that provides flexibility to the user to show detail to ...

How Macros Can Run Faster in Microsoft Excel

In this article, you will learn how macros can run faster.   Let us understand with an example: If you are working on long VBA codes for cal...

Create Drop Down Lists in Excel using Data Validation

In this article, you will learn how to make Excel drop down list from another workbook. While working on reports, you can make reports more secure so ...

Highlight Rows that Meet Criteria in Search Box in Excel

In this article, we will learn Highlight Rows that Meet Criteria in the Search Box in Excel. Scenario : Earlier we learned how to highlight ...

Evaluate Day Of The Week Using Format Cells In Microsoft Excel

Let's say you want to see the date to be displayed when you enter a date value in a cell as "Tuesday" instead of the actual date of January 27, 2014. ...

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.