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,...
Read more »Excel has a wide range of usage. In this article, we will show you how to create a calendar in a worksheet by using a macro. Except for storing and analyzing data in your Excel, you can also use it to finish other tasks. For example, you can...
Read more »In your Excel worksheet, you will format cells that meet certain criteria. When you need to select cells, you will spend a lot of time. Here we will introduce two effective methods for you to find and select those cells. Sometimes you need to...
Read more »