How to Edit a Dropdown List in Microsoft Excel

In this article, we will learn how to edit the dropdown option on cells. Data Validation is an Excel 2016 feature whose purpose is to restrict what...

How to Add Trend Line in Excel

The Trendline is used in Excel to display its equation and get the slope of the trendline. To visualize the general trend in your data, while plotting...

How to insert Quick Access Toolbar in Excel?

In this article, we will learn how and where we can use the Quick Access bar in Microsoft Excel. We can use the Quick Access toolbar to use the too...

How to Make Pie Chart in Microsoft Excel

Pie chart is used to show the proportion of the whole. Use it when numbers are equal to 100% and the chart contains only few pie slices (many slices m...

How to create column chart in Microsoft Excel

There are so many graphs in Excel in which one of the Column graph. Column graph is used to visually to compare values across a few categories when th...

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

Sorting Sheets In Ascending Order through VBA In Microsoft Excel 2010

In this article, we will learn sorting sheets in ascending order through VBA in Microsoft Excel 2010. While working on multiple sheets, you find th...

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.