标签：Excel
-
How to Add a Diagonal Line to the Cell in Excel
While making a table in Excel, you may often have the need to insert a diagonal line in the cell of header and input some texts in it, such as names, regions, months, etc. This table below is an example. I want to draw a slash in the cell A1, and input “Name“, “Decimals” separately […]
-
How to Calculate Percentages Automatically in Excel
It’s very frequent at work to make a sheet involving percentages of different departments in the whole company. Calculating percentages with a calculator surely won’t take a lot of your time. But if there’re piles of data to deal with in a short time, can you accomplish it efficiently without any mistake? If not, it’s […]
-
How to Make an Excel Histogram Display the Data Distribution
Histogram is a direct-viewing type of chart using the width and height of the rectangle to display the frequency distribution of data. It’s very common in daily life and work, which also proves its practicability. Now I want to share the detailed steps to make a histogram in Excel to display the frequency distribution of […]
-
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 […]
-
How to Start a New Line in Excel
When you input too much content in a single cell, the text will slop over the borders and affect the layout of your whole table in Excel. The best way to solve this problem is inserting a line break and starting a new line in cell. There’re 2 common methods to achieve it. 1. Manually […]
