归档： 2019 July 09
-
How to Delete the Duplicate Lines in Excel
When you’re dealing with a bunch of data in Excel, it can be a headache to find and remove all the unwanted duplicate lines. How to eliminate them in a quick and simple way? Excel itself has the function called Remove Duplicates. Let’s see how to make use of it. 1. Select the range of […]
-
How to Sort Data in Excel by Multiple Conditions
In my previous post I’ve introduced the method of sorting data in Excel by single condition. But in actual operation we usually need to sort the data according to more than one conditions. How can we do that? For example, there are some students with the same score in the grade table such as Ray […]
-
How to Sort Data in Excel by Single Condition
The content you input in Excel sheets manually may be unordered and messy, which is not conductive to view or comparison. It’s necessary to sort the data especially when you are editing a ranking table. Sorting refers to rearranging one or several fields in the table according to a specific rule. Let’s see how to […]
-
How to Batch Set the Row Height and Column Width Precisely in Excel
It’s common to adjust the row height and column width in Excel while editing a table, especially when the content is too much to fit in the cell’s size. The most direct way for this situation is moving your mouse to drag the rows or columns, which you should’ve used for many times before. But […]
