Office Solutions

2 Methods to Sort Alphabetically by Last Names in Your Word Document

In today’s article, we will provide you with 2 methods to sort alphabetically by last names in your word document. Basically, we are not alien to the “Sort” feature in Word. It helps us a lot in setting numbers and paragraphs in a particular order. And today, we will bring the topic of sorting alphabetically by last names if they are in sequence of: first name, last name. Obviously, you will not succeed in trying in usual way. While if you take our 2 ways introduced in the following...

Read more »

3 Effective Methods to Calculate Values Based on Cell Colors in Your Excel Worksheet

Different cell colors can help you identify the values in cells. When you need to calculate values based on cell colors, you can use the 3 methods in this article. In an Excel worksheet, you will certainly mark different colors for different cells. Most of the time, the same color will be in different cells in a range. The image below shows a worksheet with different cell colors. When you need to calculate the values by the cell color, you will find that it will be hard to select those...

Read more »

2 Ways to Convert Automatic Numbering to Normal Texts in Your Word Document

In this article, we intend to show you 2 ways to convert automatic numbering to normal texts in your Word document. Generally, we benefit a lot from the AutoNumber feature in Word. It saves us much trouble in listing items and organizing paragraphs. However, here is the twist. A document normally requires revisions more than once. And it’s in the process of adding and deleting texts that the numbers get affected. Therefore, we need to convert these “dynamic” numbers to plain texts. So...

Read more »