The ComboBox is a special feature of Excel. If we ever need to choose from multiple options, VBA ComboBox is there for the job. Not only that, but we can also ...
In this article, I will discuss how you can calculate the Sortino Ratio in Excel. I will calculate this using excel formulas and VBA. Before starting the ...
This article will discuss how you can open multiple excel files in one window. Often working with Microsoft Excel, we may need to open and view multiple ...
This article will discuss how you can protect formulas in Microsoft Excel. Sometimes, when you share spreadsheets with other people, you might want no one to ...
In this article, I will discuss how you can recover an unsaved excel file after a crash. A crash can happen due to several reasons. For example, your PC can ...
In this article, I will discuss how you can hide the Toolbar (Ribbon) in excel. The Excel Toolbar is located on the top of the excel window and contains a ...
While working in Microsoft Excel, we often have to calculate the difference between two times. Calculating time differences is a very common operation in ...
In this article, I will discuss how you can create a client database in Microsoft Excel. Usually, a traditional database has tables, fields, records, primary ...
In this article, I will discuss how you can convert a mailing list in Excel into MS Word mailing labels by applying the Mail Merge feature. Often when we have ...
In this article, I will discuss how you can convert CSV files into excel files with multiple columns (.xlsx format). As CSV files are easy to operate and open ...
While working with Microsoft Excel, often we have to make the workbook read only with a password for the sake of data integrity. We protect workbooks with ...
This article will discuss methods to subtract excel data based on different criteria. While working with Microsoft Excel, we subtract cell values using the ...
In this article, I will discuss how you can separate the date from text strings in Microsoft Excel. While working with excel, often we receive spreadsheets ...
In this article, I will discuss how you can open two excel files separately in different windows. People who are using updated versions of excel won't face ...
Sometimes, while working in Microsoft Excel, we see some rows not showing although they are not hidden. In such cases, the usual Hide & Unhide option of ...
- 1
- 2
- 3
- …
- 8
- Next Page »