Office Solutions

How to Clear All Error Values Quickly in Your Excel Worksheets

In an Excel worksheet, you meet error values in using formula or in other aspects. And in this article, we will discuss about how to clear all error values in your Excel worksheet quickly. Excel is specially designed to calculate and analyze data and information. But sometimes you will find that there will be errors in cells. Reasons can be various, such as there are some wrong elements in a formula. Thus, you need to clear the error values in your sheet. However, sometimes there are many...

Read more »

How to Auto Categorize Appointments in Outlook Calendar

Many people prefer to use color category in Outlook to classify emails, contacts, appointments, etc. This article will look at how to let Outlook color categorize appointments automatically. So as to manage my appointments in Outlook more effectively, I tend to color categorize them. One day, after I created one appointment, I intended to color categorize it. An idea occurred to my mind. How can I have Outlook do this work automatically for me? If you have the same aspiration, read on to...

Read more »

How to Convert Between Text and Table in Outlook Messages

As we all know, in MS Word, we can convert text to table and vice versa freely. The same holds true for Outlook. This article will discuss about how to convert between text and table in Outlook messages. Sometimes when I try to copy a table of statistics from an external file to Outlook message, the table will be shown in text instead of in table. It may mess up the data. In this case, I wish to convert the text to table without needs to create a new table and input the data one by one. Here...

Read more »