• ## How to Fully Display Long Numbers Over 11 Characters in Excel

时间：2019-10-16

Have you ever input long numbers in Excel and only to find the digits in the middle have been abbreviated? It’s actually because of scientific notation, which automatically abbreviates the number over 11 digits in length. So how could we fully display long numbers in Excel? One solution for this situation is converting the property […]

• ## How to Use Format Cells to Quick Enter a Series of Data in Excel

时间：2019-10-16

When editing Excel spreadsheet, you can hardly avoid entering a series of similar data, like departments in company, product ID, e-mail address, etc. Some of them are almost the same, just a little difference in the begging or ending, but you still need to input them completely over and over, which is quite exhausting. In […]

• ## How to Remove the Start Screen in Excel to Open New File Directly

时间：2019-10-16

Are you tired of clicking the Blank workbook button to create a new file every time opening Excel? The truth is you may never use those featured templates in the start screen, but still waste your time here compulsorily. So why not disable this page and enter a new file directly? For this purpose, you […]

• ## How to Calculate the Time Difference Quickly Using Excel Functions

时间：2019-10-16

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

时间：2019-10-16

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 […]