Excel functions can help you a lot in your work. In this article, we will discuss about the difference between the built-in ROUND function and the VBA ROUND function. You will certainly have used the ROUND function in your Excel. If you also use...
Read more »In an Excel worksheet, you may need to extract numbers from values in cells. And in this article, we will introduce you two methods to extract numbers from Excel cells. There are many cases that both numbers and texts are in same cells. In order...
Read more »If you can use gradient color in your work, you are sure to improve your work efficiency. In this article, we will introduce two methods to fill your worksheet with gradient color. It is very easy for you to fill a cell or a range with a certain...
Read more »Sometimes you will need to list all the file names in a folder in an Excel worksheet. Thus, you can better manage those files. In this article, we will introduce two effective methods to copy the list in a folder. In an Excel worksheet, you can...
Read more »Sometimes in a column, the cells will contains both numbers and texts. Here we will provide two methods to sort a column with numbers and texts. Sometimes there will be numbers and texts in the same cells in a column. If you need to sort this...
Read more »Special symbols can represent some special meanings. Therefore, in Excel, you will certainly need to insert some special symbols to assist your work. In an Excel worksheet, you will certainly input a lot of data and information into it....
Read more »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 »When there are many data series in a worksheet, the corresponding line chart will also be in a mess. In order to make the chart clearer, we have the two methods in this article. The line chart in Excel can show data and information better. But...
Read more »