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 in calculation, such as the byte unit. For example, you can see the numbers in the image below.
There are several numbers with the unit “KB” in this column. On the other hand, it is impossible to directly use a formula to calculate the numbers with...
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 information. In the image below, you can see that there is an ordinary column chart in a worksheet.
All the colors of those columns are the same. This is the default setting in Excel. And now you can also change the column colors to make your Excel more...
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 will also regard some additional words as mistakes. Those additional words can be the name of a company, the name of certain products or some abbreviations. At this moment, you can directly ignore it. However, the next time you check your workbook,...
Read more »
