Categories：Excel Tips
-
How to Insert Thousands Separators to Long Numbers in Excel Cells
While processing data in Excel, we may need to type some long numbers in Excel cells. As we all know, a long number can be very easily mistaken. So can we add thousands separators to make them more intuitive? The method is quite simple. 1. Select the data that you want to insert thousands separators […]
-
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 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 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 Customize the Page Margins in Microsoft Excel
Page margins decide the location and size of the Excel sheet in a printed paper. Just like in MS word, you can also customize the page margins in Excel to make it meet your needs, and thereby print a better document. 1. First, click File in the upper left corner. 2. Next, click Print in […]
