When you are working on an Excel workbook, you may need to refer to the path of this file. In this article, we will show you 3 methods to get the path.
Getting the path of the current workbook seems to be very easy. However, if you close the folder and couldn’t remember the exact location, you will find it hard to get the path especially, especially when there are many files in your computer. You can certainly use the search feature in your computer.
But if there are many files in your...
Read more »
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 content,...
Read more »
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 »
