How to Create Dependent (Cascading) Drop Down List in Excel Using 5 Different Techniques

So far in this Data Validation series, we have learnt to create normal drop down list and dynamic drop down list using different techniques with data ...

How to use Color Scale in Conditional Formatting

In this article, we’ll learn the use of Color scales option in conditional formatting. Also, answer questions like, why we use it in our reports and...

Embed Excel file into Word file

How to Insert an Excel document in Word file? In this article we will learn how we can embed the Excel file or insert the Excel table into word file....

How to Highlight the Incell Graph

In this article we will learn how to highlight the Incell graph on the basis of high score in Microsoft Excel. To solve this problem we will use Condi...

Highlight Every Alternative Rows and Column

In this article, we will learn how we can highlight every alternative row and every 3rd column in Microsoft Excel. We will use Conditional formatting ...

What are Excel Ribbons or Excel Tabs?

In this article, we will learn about Excel Ribbons or Excel Tabs? Scenario: Once you open the excel software from the program menu, the firs...

How to Minimize the Excel Ribbon

In this article, we will learn How to Minimize the Excel Ribbon Scenario: Show collapsed ribbon in full view If the Excel ribbon is minimized s...

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.