Office Solutions

How to Consolidate the Values in Multiple Worksheets

In Excel worksheets, many related values may spread among multiple worksheets. And in this article, we will introduce how to consolidate such values. In an Excel file, there will certainly be many worksheets. For example, in this Excel file, you can see that this is the sales volume of different sellers. Besides, there are five months in the worksheet. And for each month, there is an independent worksheet. But now you want to know the total sales volume of each person. If you add those...

Read more »

How to Quickly Access the Frequently Used Search Queries

If you constantly utilize the same search queries when searching items in Outlook, you can utilize the following methods introduced in this article to rapidly access the queries. My mailbox contains a great amount of emails. It is extremely difficult to search out my target emails. Thus I often use Outlook Search Tools. But I’m considerably averse to entering the repeating search queries. Here are my solutions。 Utilize Outlook Recent Searches Outlook provides us with a useful and handy...

Read more »

What to Do If Attachments Vanish after Emails Are Sent Out

Sometimes we may find that the original email attachments are replaced by a winmail.dat file. In this article, we will explore why the issue happens and how to solve it. I have ever received several messages with winmail.dat file. Then I called the friend and asked him why he always sent the file to me. But he expressed that he had no idea about it either. He disabled his antivirus software but it didn’t make any effects. Thus I suggested him to consider other factors. He finally found the...

Read more »