归档： Olivia
-
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 […]
-
4 Office Tips to Prevent Computer Radiation Effectively
If you regularly use your PC for more than four hours, then you have to pay attention to the pollution of office environment, especially the influence of health that computer brings. The side effects are mainly manifested as: watery eyes, visual deterioration and dizziness. For females, computer radiation could also have a negative effect on […]
-
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 Insert a Calendar in Microsoft Word
There are a lot default charts and images in Word which could meet our various needs, and I’ve already shared the tip of how to insert date & time, but sometimes you might need to insert a calendar in the document for a more visual display, and it is easy to schedule the whole month. […]
-
How to Set, Change or Delete Background Page Color in Microsoft Word
We’ve shared the tip of how to change the theme color, and also introduced how to change the picture color in Word. When editing a document, the default background page color is white, you could set a color for it to bring interest to your document, especially when there are a lot pages describing different […]
-
How to Limit the Characters Per Line in Microsoft Word
You must have learned how to adjust character spacing in our previous post, but when you are editing a document with exact specifications, it is necessary to limit the characters per line and lines per page as well. On the other hand, it can also limit the characters for the whole document. Just follow the […]
-
How to Batch Delete the Contents of a Table in Microsoft Word
You might come across such a time when editing a table in Word, some of the data are incorrect which cause errors in the entire table, thus you need to delete all contents for a new beginning. If there are too many characters, deleting them one by one can be a waste of time, and […]
-
How to Change the Default Save Location in Microsoft Excel
When you done with a workbook and save it, Excel will save it to My Documents folder automatically. But sometimes you need to save the workbook to another folder which is more consistent with the use of your habits. In this case, you need to select the correct location in the Save As dialog box, […]
