In Excel, you will find that sometimes the autocomplete of cell values will not work. And in this article, we will dig out the reason. In Excel, sometimes you need to enter duplicate contents into a column repeatedly. In such a case,...
Read more »The cell styles can help us identify data and information better. And in this article, we will discuss about how to use customized cell styles that created and stores in other workbooks by merging styles. In our previous article How to Customize...
Read more »Some basic manipulations in Excel are very clever. And in this article, we will introduce 3 methods to move around a worksheet. You will certainly move around worksheets to check for some data and information. And except for using the mouse...
Read more »You will certainly use the bar chart to analyze important values. And now we will demonstrate the creation of a bi-direction chart in Excel. There are many methods about charts in Excel. Now if you want to compare the values in cells, you can...
Read more »Some features in Excel may cause confusion to us. And here we have solved the problem with the drop-down list in Excel. In our previous article “How to Create Multiple Choice Questions in an Excel Form”, we have introduced the steps to create a...
Read more »Excel has many hidden functions that enable this software to be a good helper. Thus, here we will discuss about the auto text expansion in Excel. In Excel, you will find that sometimes you will misspell some words. However, if you press “Enter”...
Read more »The protected worksheet can protect data security very well. In addition, we will show you how to edit specific ranges in a protected worksheet. In our previous article, we have talked about protecting worksheet. And you may refer to it to see...
Read more »Excel has provided many features for us to calculate data. Here we will introduce 3 useful methods to sum values of same cells in multiple worksheets. Sometimes in an Excel file, you will need to calculate the total value of certain cells....
Read more »In our previous articles, we have talked about how to hide and show workbooks and worksheets. And now we will continue discussing about easy ways to hide specific rows and columns. There are three different objects of the hide and show feature:...
Read more »In an Excel worksheet, if you have a lot of data and information, the interface will be in a mess. Thus, you can add groups to classify your data and information. In Excel, you can also add groups to your information. And with groups, you can...
Read more »