标签：Excel 2016
-
How to Recover an Unsaved File in Microsoft Word, Excel or PowerPoint
If you close a file in Microsoft Word, Excel or PowerPoint before saving it by accident, take these steps to recover the unsaved content in Office instead of restarting your hard work. 1. You might unexpectedly click Don’t Save button in Microsoft Office dialog box. 2. Click File at top left in the Ribbon. 3. […]
-
How to Quickly Enter a Long Number with Multiple Zeroes in Excel
When making the table about financial capital in Excel, we often enter some long numbers such as amount ninety thousand, fifty million or others contain more zeroes. They might make give you a headache and it is also very easy to cause input problems. So how can we quickly enter a long number with multiple […]
-
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 Convert Arabic Numerals to Roman Numerals in Microsoft Excel
Luckily we don’t use the Roman numerals much today, a kind of counting way which is really complicated to remember, and some of them look similar but have completely different meanings. Due to the requirement of work, in some cases, Arabic numerals might need to be displayed as Roman numerals, and is there any easy […]
-
How to Batch Create Multiple Sheets with Different Titles in Microsoft Excel
In previous post, we have introduced the tip of how to batch create multiple documents with different titles in Word. You might have the same problem when editing with Excel. The method is quite different but also easy, but it can save your time and improve the efficiency. Let’s see what we can do about […]
-
How to Batch Convert Positive Numbers into Negative Numbers in Microsoft Excel
There are a lot tricks for you to explore while working with Excel, processing data in batch is just one of the common tools. I’ve shared the tip of how to batch convert number to date format, and you might also need to convert positive numbers into negative numbers when calculating the balance. So how […]
-
How to Batch Translate Text in Microsoft Excel
In an age of widespread global trade, multinational corporations are born every day. You are likely to interact with colleagues from different countries, and work with documents in different languages. Copying the text into a translator is a waste of time, why not use the tool in Excel to batch translate it and seamlessly switch […]
-
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 Prevent Entering Duplicate Data in Microsoft Excel
When processing data with Excel, sometimes duplicate data might lead to incorrect results or even serious consequences. We have already learned how to delete or merge the duplicate cells before, but it is actually possible to be prevented from the very beginning. This little trick demands Excel to auto alert you every time when entering […]
-
How to Shrink the Text in Excel Cells to Fit the Column Width
When the text is too long to be fully displayed in an Excel cell, you can use AutoFit feature to enlarge the cell to fit the contents, but it could result in too much blank space in the rest of the row and does not meet the requirements for files in a specific format. Here […]
