标签：Excel 2019
-
How to Make Excel Files Compatible with Earlier Versions
If you work with a recent version of Excel like Excel 2016, Excel 2019, the workbook you created may not be displayed correctly in Excel 2003 or Excel 2007. Thus when you send your Excel files to your colleague or friends, there’s a chance they can’t open them normally. In this case, you’d better make […]
-
How to Use AutoFill in Excel to Quick Enter a Series of Data
Microsoft Excel is a particular powerful tool. When you make use of it, there are lots of tips can help you process the data automatically. For example, if you want to enter a series of data or a line of increasing numbers into a spreadsheet, you don’t need to type them one by one manually. […]
-
How to Split Data into Different Columns Using Flash Fill in Excel
Making a table in Excel requires you to put different types of data in different columns. But sometimes the data collected by others or uploaded from a TXT file may not be organized that well. You can of course split the data in a column into different columns manually by cutting and pasting. But if […]
-
How to Paste Data Skipping Blanks in Microsoft Excel
Copy and paste is a basic operation in Microsoft Excel that should be familiar to everyone. But what if you need to copy a column of data with blanks to another column? If you copy it directly, the data in the target column would be overwritten by the blanks. You can also, of course, copy […]
-
5 Practical Excel Functions to Improve Your Working Efficiency
Microsoft Excel is a widely used office software which you must have tried or at least heard in life. It’s convenient, powerful and also complicated for some newbies since there seems to be too much to learn. They may end up doing repetitive work manually without knowing how to use Excel formulas to complete their […]
-
How to Change the Default Font of Excel 2019
Every time you open an Excel file, the font will turn back to the default setting even if you’ve changed it for tons of times in previous file. To fit your taste more, you can change the default font of Excel actually. Click File tab on the top-left corner. Click Options in the left sidebar. […]
