归档： Cordelia
-
How to Compare Two Documents in Word Side-by-Side
A Word document could be modified for several times by more than one people in daily work. Is there a simple way to compare these different versions of Word documents side-by-side and pick out exactly the one you want? In fact, you can make use of the compare feature of Word itself. 1. Click Compare […]
-
How to Keep Table Headers on Each Page in Word
When you are editing a file with tables, you may encounter a situation that a table is too large to stay intact. Half of table is extended to the next page, and the data can hardly correspond to the content since there’s no header. So how can we keep the same table header on each […]
-
How to Enable Horizontal and Vertical Ruler in Word
In Microsoft Word, Ruler is a useful tool for typesetting. But it’s not always shown by default. It’s better to toggle it on if you want to adjust the layout more intuitively. So, how to enable the horizontal ruler and vertical ruler in Word? How to Enable the Horizontal Ruler It’s very easy to add […]
-
How to Change and Customize the Page Margins in Word
Page margin is an important factor of the layout in Word. It decides the width of the text section on a page. If you want to typeset a Word document to make it meet your needs, you can customize the page margins at first. 1. To set a proper page margin for your document, click […]
-
How to Set the Page Footer in Word
Page footer often appears in formal documents, books and magazines. It conveys many information like page number, date, company name, document title, etc. and the method to insert a page footer in Word is quite easy. 1. First, double click the footer area to enable Header & Footer Tools. 2. Click Footer and choose a […]
-
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 […]
