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 »In general, all the tasks will be placed in the default Outlook task folder, no matter your won tasks or the tasks which you assign to others. This article will introduce how to make Outlook to auto move tasks assigned to others to a specific task...
Read more »Some users hope that they can control Outlook’s sending feature, namely prevent emails from being sent out directly when they click the “Send” button. In this article, we will introduce 5 approaches. At times, after you click the “Send” button,...
Read more »