The custom sort in Excel is a very useful feature. In this article, we will talk about how to automatically update custom sort in a range by using the Excel VBA. When you use the custom sort, you will find that this is an amazing feature in...
Read more »Data theft can be minimised by disabling various menu and right-click features in Excel. We discuss below how to do this using VBA. It is assumed the reader has the Excel Developer ribbon displayed, and is familiar with the VBA Editor. The User...
Read more »It is useful sometimes to read a worksheet line-by-line and selectively take data from it. An example below shows how to do this. The article assumes the reader has the Developer ribbon displayed and is familiar with the VBA Editor. If not,...
Read more »Excel can do virtually anything; whether it should be made to do everything is another matter. While the spreadsheet is very powerful in manipulating data, it isn’t too great at storing normalised data. Harnessing Excel to a relational database like...
Read more »It is easy for you to sort data in a range in the worksheet. Furthermore, now you can also sort data in a column chart by the 2 effective methods that are introduced in this article. When you demonstrate data and information in a column chart,...
Read more »When you need to show the information in a chart according to the values, you can create a funnel chart. Hence, you can use the two methods in this article to create such a chart. The information in a funnel chart can show the original data in a...
Read more »When you import contents into Excel from other sources, there will be additional spaces in Excel cells. In this article, we will introduce 3 effective methods to remove spaces in cells. Removing spaces in cells can be annoying because it is...
Read more »Sometimes you need to copy cells that meeting certain criteria. And here we will introduce 2 useful methods to copy the target cells. In an Excel worksheet, there will certainly be a lot of data and information. However, those cells contain...
Read more »When you are working on an Excel workbook, you may need to refer to the path of this file. In this article, we will show you 3 methods to get the path. Getting the path of the current workbook seems to be very easy. However, if you close the...
Read more »Different cell colors can help you identify the values in cells. When you need to calculate values based on cell colors, you can use the 3 methods in this article. In an Excel worksheet, you will certainly mark different colors for different...
Read more »