Excel File Recovery

How to Utilize the Excel’s Double Click Event

Processes can be simplified for the user in some circumstances by using the Double_click event. This event can call macros, depending on the cursor position in the spreadsheet, and write the information to a database. To take this article to its natural conclusion will require a database and a knowledge on how to connect to, and update,  it. It is assumed the reader has the Developer ribbon displayed, and is familiar with the VBA Editor. If not, please Google Excel Developer Tab or Excel...

Read more »

How to Using Excel to Read and Write an External Database

Excel can do virtually anything; whether it should be made to do everything is another matter. While the spreadsheet is very powerful in manipulating data, it isn’t too great at storing normalised data. Harnessing Excel to a relational database like SQL Server enhances the application’s power. To start with, you will need MS Access or the more stable and free - SQL Server Express. It is assumed that the reader has the Excel Developer ribbon displayed, and is familiar with the VBA Editor...

Read more »

2 Methods to Sort the Columns in a Column Chart in Your Excel Worksheet

It is easy for you to sort data in a range in the worksheet. Furthermore, now you can also sort data in a column chart by the 2 effective methods that are introduced in this article. When you demonstrate data and information in a column chart, the order will be the same as in the worksheet. The image below shows such a typical column chart that has the same order with the original range in the worksheet. When you need to change the order, or sort the columns in the chart, you may find...

Read more »