Microsoft Excel always fascinates me with its awesome features, which help us do lots of stuff easily. If you are dealing with a lot of data and as it keeps on changing, you might come across a ...

Excel does not always handle a cluttered page very well, especially if you intend to use a workbook on multiple versions of Excel. In this example we will use the Worksheet_SelectionChange event as a ...

Many of us use Microsoft Excel to calculate the budget or do some additions and subtractions. We also know that it supports Macros which helps us to automate our tasks. An Excel sheet is no stranger ...

If you manage data in multiple Excel spreadsheets, you can use the Consolidate Data wizard to merge data from several spreadsheets or workbooks into one master sheet. The Consolidate Data wizard ...

In this article we will show you how to display multiple columns in a validation list in Excel. We will show you a method that can then be applied to your data. To create a validation list with ...