归档： 2019 October 16
-
How to Fully Display Long Numbers Over 11 Characters in Excel
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
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
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
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 […]
