Excel Solutions

2 Methods to Make Column Chart More Intuitive by Changing Column Colors in Excel

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 »

2 Methods to Add Additional Words to Your Excel Dictionary

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 »

How to Quickly Copy a Cell Down or to the Right in Your Excel Worksheet

Sometimes in your Excel worksheet, you need to input the same contents into multiple cells. And in this article, we will show you how to fulfill this task by copying a cell down or to the right in worksheet. In certain circumstance, you need to input the same contents into a range. If those cells are adjacent, you can first input the contents into a cell and then copy it down or to the right. And the target area can be a cell or a range. Instead of using the copy and paste feature or the...

Read more »