When you input numbers with parentheses into cells, they will change into negative numbers. And in this article, we will help you figure out this problem. If you deal with Excel frequently, you may have already found this phenomenon. When you...
Read more »Excel has provided you with many practical functions. And in this article, we will introduce three methods to help you quickly know the function arguments. You will probably have met with such a condition: When you are working in Excel and you...
Read more »When you are working on your Excel file, you will probably have a need to note down the current date and time. Therefore, here we will discuss about 3 methods to achieve this task. Knowing when you have modified a file is very important for you...
Read more »Excel haven’t provided direct feature to convert KB to MB and vice versa. Hence, here we will introduce two methods to solve this problem. In an Excel worksheet, you will input numbers with certain units. However, some units cannot participate...
Read more »The column chart is frequently used in Excel. And to make it more intuitive, now you can use the 2 methods to change the column colors. Column chart is the most ordinary chart in Excel. It is always used to display and analyze data and...
Read more »In your Excel worksheet, you will certainly input some additional words into cells. Hence, here we will discuss about how to add those additional words to the Excel dictionary. When you use the spelling feature to check the worksheet, the Excel...
Read more »Sometimes you need to use checkboxes to assist your work. And show certain contents in certain cells according to the values of checkboxes can show information clearer. In this article, we will show you 3 effective methods to show or hide cell...
Read more »Some blank cells in a worksheet are actually not empty. But their existence will make you confused. Therefore, you need to find those non-empty cells in your Excel worksheet. There are many conditions that a cell will be non-empty while the...
Read more »In older formats of Excel workbooks, you cannot use some new features. Thus, here we provide two effective methods to convert the file formats. If the format of a file is an older version, you cannot use the new features in newer version of...
Read more »Checkbox is a good helper when you will analyze certain information. And in today’s article, we are going to introduce the method to quickly select or unselect all checkboxes in your Excel worksheet. Checkbox is a kind of form control object in...
Read more »