Categories：Excel Tips
-
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 […]
-
The Quickest Way to Sum columns or rows in Excel Spreadsheet
Among all these ways to calculate the summation in Excel, the fastest way as I think is to use shortcuts. With it, you can even sum multiple columns or rows in seconds. The only thing you need do is selecting the values to sum, and press Ctrl+= on the keyboard. For example, if you want […]
-
How to Batch Add Units to Cells in Excel Spreadsheet
Adding units to one or several cells in Excel might not be difficult and many people are likely to type them after the values directly. However, this approach is not just time-consuming, but can also affect the result for calculation and invalidate some formulas. So, how to add units to multiple cells in Excel exactly? […]
-
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 […]
-
How to Repeat a Print Title on Each Page in Microsoft Excel
If there’s too much data in an Excel spreadsheet, it will inevitably be divided into several pages when printing. And it might be difficult to figure out the corresponding meaning or description of each value. The best way to avoid this kind of trouble is to repeat a print title on each page. 1. First, […]
-
How to Converted Decimals into Fractions in Microsoft Excel
When you are processing data in Microsoft Excel, the results of calculations or the numbers you need to enter won’t always be integers. So, if you’ve got a batch of decimals in the worksheet, how can you convert them into fractions or vice versa? There’s 2 commonly used methods: 1. Percent Style First, select all […]
