Any action you wish to apply on a cell requires the cell to be selected first. Normally, you just click a cell or drag your mouse across multiple cells. However, if you did not capture the entire area ...

A complex Excel 2007 workbook could require multiple sheets. By default, Microsoft provides three sheets on each workbook, but you can add as many as you need. Clicking the "Insert Worksheet" button ...

There's a ghost in your Excel spreadsheet. It's that invisible text box you keep accidentally clicking, or the chart that refuses to be selected. Instead of losing your mind, use the Selection Pane, ...

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

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