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 »In the following article, let’s go through the 6 quick and awesome ways to switch between open Word document windows. Now and then, it’s quite often to conduct multiple tasks at one time. And when it comes to Word, opening several documents at...
Read more »By default, in Outlook today window, we can only sort the tasks by Importance, Due Date, Start Date or Creation Date. But some users wish to sort them alphabetically, namely by subject. This article will introduce how to achieve it. Many people...
Read more »We’re permitted to request read receipt when sending Outlook emails. But someone even wishes that Outlook can auto request the read receipt when they send specific emails. This article will make it realized with Outlook VBA. In general, if you...
Read more »In this article, we would like to share 2 easy methods to adjust contents to fit in cells in your Word table. When deal with a table in Word document, it’s hard to ensure all table cells stay in fixed size. Normally, with more words input in a...
Read more »This article is cropped to provide you with 2 quick and manageable ways to auto fit tables to contents or Page in your Word document. Inserting a table to hold data is now inevitable in Word using. More often than not, we don’t stop in merely...
Read more »In this article, we will introduce 2 methods for you to alternate row or column colors in your Word table. When it comes to a long table, we always find it pretty tiresome to stare at those numbers and try so hard not to make a mistake. But now,...
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 »