标签:Excel
-
How to Print an Excel Worksheet on Center of a Page
In general, if the worksheet you want to print doesn’t take up a full page, it will be automatically placed on the upper-left corner of the page (like the picture below), which won’t look good apparently. The better way is to center the worksheet you want to print on the page. Switch to Page Layout […]
-
How to Add Text on Top of A picture in Excel
You may insert pictures to Excel spreadsheets a lot and have been already familiar with the steps. But out of the need for designing or processing data, it has a chance to require you to add text on top a picture. Here’s a simple guide to achieve this goal. Click Insert – Pictures and select […]
-
How to Make a Table Header with 2 Slashes in Excel
In addition to a cell with a diagonal line, sometimes you may also need to make a table header with 2 slashes in Excel if there are multiple kinds of data to be organized. It requires you to insert 2 lines in a cell as well as text on each side of the lines. So […]
-
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 Create an Organizational Chart in Microsoft Word
An organizational chart, also known as organigram, is used to illustrate the hierarchical relationship of an organization, such as the relationship between depart managers and their subordinates in a company. You must have seen it and may also have the need to make a similar chart for some reasons. Luckily, you can make an organizational […]