归档： Cordelia
-
How to Calculate the Time Difference Quickly Using Excel Functions
In practice, we often need to calculate the difference of years, months, weeks or days between 2 separate dates. And like many other calculations, Excel functions can help you calculate the time difference quickly and accurately. Let’s see how to do it. Case 1: Calculate the Difference of Years Formula: =DATEDIF(A2,B2,”y”) A2, B2 corresponds to […]
-
How to Turn on or Turn off Automatic Hyperlinks in Word
You may find that the URL entered in Word document will directly be converted to a hyperlink once you press [Enter] key. It ensures you can visit the website very quickly. But if you want a pure text link only, right-clicking it and choosing Remove Hyperlink can be a headache. Is there a way to […]
-
How to Insert Page Numbers to Excel Files When Printing
Excel is a powerful tool in which you can process a huge amount of data. But if the file you are editing is so large that you must drag the mouse for a while to view all the content, you may want to add page numbers to the Excel file while printing it out to […]
-
Tips to Quick Fill in a Word or Excel Table with the Clipboard
When filling in a table in Microsoft Word or Excel, it’s common to enter some specific information for multiple times. To save the time on inputting them repeatedly, there’re some features like drop-down list you can turn to. But do you know the clipboard can also work as an alternative to help you quick fill […]
-
How to Fold Specific Rows or Columns in Microsoft Excel
An Excel spreadsheet can be very large containing a lot of information. If you want to make it more concise and intuitive to find the specific data, you can fold the rows or columns by adding a data group. Here’s a simple guide to do it. Fold Rows in Excel 1. Select the rows you […]
-
How to Calculate the Absolute Value with ABS Function in Excel
Calculating the absolute value is very common in Excel data processing. To fulfil the task quickly and accurately, you don’t need to do the operations by your own. Just make use of ABS function, you can get the absolute values of a batch of data in seconds. 1. Create a new column to output the […]
-
How to Batch Delete Blank Cells in Excel
What would you do if you find some unwanted blanks in Excel sheet? Deleting them one by one is obviously a waste of time. Is there any quick way to remove all the blank cells at once? Well, the Go To feature of Excel may help you. 1. First of all, select the whole sheet. […]
-
How to Create a Lined Paper Template in Microsoft Word
If you want to create a lined paper in Microsoft Word and print it out for some special requirements, you actually don’t need to download the template from Internet or draw the line by yourself. Just imagine the lined paper is a one-column table without vertical borders, the method is quite self-explanatory now. 1. First, […]
-
How to Add a Bookmark to Mark the Specific Place in Word Document
If you are viewing a long Word document which can’t be read completely at once, adding a bookmark can be as helpful as a real bookmark in life. Let’s see how to use the feature in Word 2016. 1. Open a document in Word, put your cursor at the place you want to make a […]
-
How to Create a Paper Template with Grids in Word
The default paper of Microsoft Word is pure white. If you want some special templates to meet your special need, like the grid paper, you need to make some changes at first. Here’s a simple guide to create grid papers with Genko Setting in Word. 1. First, go to Layout tab and check if there’s […]
