In your Excel worksheet, you will format cells that meet certain criteria. When you need to select cells, you will spend a lot of time. Here we will introduce two effective methods for you to find and select those cells. Sometimes you need to...
Read more »If you are using Gmail account via IMAP in Outlook, you may find that the emails, which you’ve deleted from Outlook, still exist on Gmail server. This article will teach you how to make the emails to get deleted from both Outlook and IMAP...
Read more »In reality, most of you may hope to create an Outlook rule to auto move the emails with specific CC recipients. But Outlook rule doesn’t support checking CC recipients. So this article will teach you how to realize it with Outlook...
Read more »In today’s article, there are 6 useful tips available to help you make easy use of numbered or bulleted lists in your Word document. “Bullets” and “Numbering” are 2 useful features in Word, ensuring items in your Word document are organized in a...
Read more »Many users hope that Outlook can auto look for specific words in the attachment names and then save the specific attachments to a local folder on their computers. This article will teach you how to accomplish it with Outlook VBA. In my daily...
Read more »When there are many data series in a worksheet, the corresponding line chart will also be in a mess. In order to make the chart clearer, we have the two methods in this article. The line chart in Excel can show data and information better. But...
Read more »In this article, we will talk about 5 possible causes of printing useless blank pages in Word and the solutions to them respectively. Now and then, frequent users of Word will bump into the situation of having blank pages printed instead of the...
Read more »Sometimes you may be required to change the Outlook meeting organizer for some reasons. But in fact, Outlook doesn’t support this, so you have to recreate a meeting with the same attendees and details. This article will teach you a quick...
Read more »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 »