Excel File Recovery

How to Auto Log the Time When You Open and Close an Excel File

Knowing when you have edited or viewed Excel file is important in your work. In this article, we will show you how to automatically log time when you open or close the Excel file. By logging the time of opening an Excel file and closing a file, you will know at what time you have modified the file or viewed the file. With those records, you can know your work process. In addition, keeping track of files can also help you prevent your files from being changed by other peoples, deliberately...

Read more »

How to Represent Data with a Pie of Pie Chart in Your Excel Worksheet

Chart in Excel can reflect data and information more intuitive. In this article, we will introduce you the pie of pie chart in Excel. Pie chart can well present the relationship of each data set. But do you know that you can also create a pie of pie chart in your worksheet? With such a chart, not only can you display certain data and information, but also you can see the subset of a certain classification. The image below shows the sales volume of a product. Except for the sales volume...

Read more »

2 Effective Methods to Keep Leading Zeros in Cells in Your Excel Worksheet

When you input leading zeros into cells, you will find that Excel will remove zeros from cells. Here we will introduce two methods to keep them in the cells. There are cases that you will input numbers with leading zeros. However, even if you manually input the zero into cells, you cannot see it when you press “Enter”. This will cause trouble to you when those leading zeros have special meanings. In order to help you solve this problem, you can use the two methods below. Method 1: Input...

Read more »