How to Highlight Cells via Data Bars in Your Excel Worksheet

Sometimes you need to highlight cells to make them different. And in this article, we will show you how to highlight cells by the data bars in worksheet. Some highlighted cells can representative certain information. Therefore, it is necessary for you to use this feature. In the image below, you will see the sales volume and the monthly sales growth of a product. Now you need to analyze the sales growth in column C. In order to get better result, you can highlight this column. Highlight...

Read more »

How to Quickly Remove Attachments from Emails Older Than a Specific Date with Outlook VBA

So as to keep Outlook mailbox in small size and prevent Outlook data corruption, it is suggested to remove attachments from the emails which were received or sent a specific period ago. This article will help you quickly accomplish it with Outlook VBA. As we all know, with Outlook mailbox larger, Outlook data will become much more vulnerable. Therefore, I get used to removing the attachments in the aged emails which are older than a specific date, since that I usually have saved these...

Read more »

How to Clear the Recent Search History in Your Outlook

When you search items by means of the instant search, Outlook will remember the recent search history automatically. This article will focus on how to clear this history. To find out the recent search history list, you should click into the search box to bring out the “Search” ribbon. Then you are able to find the “Recent Searches” button in the “Options” group. Click on it, and the recent search history will show up in the drop down list, like the following...

Read more »