标签:Excel
-
How to Add or Remove Cell Borders in Excel
To add or remove cell borders in Excel, the quickest way is using shortcuts in your keyboad. Try following steps: Add Cell Borders in Excel 1. Select the cell or the range of cells you want to add borders. 2. Then press [Ctrl]+ [Shift] +[&] in your keyboard. 3. Now you can see the borders […]
-
How to Round Numbers Up or Down in Microsoft Excel
In the actual mathematical operations especiall financial calculations, you may often encounter the problem of rounding numbers. Although Excel allows you to define the decimal places in cells, the number itself is not really rounded. It could lead to some minor errors in financial operations. So is there any really easy way to round the […]
-
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 […]