归档： Cordelia
-
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 […]
-
How to Change the Color of a Picture in Microsoft Office
Working with Microsoft Office programs often requires you to insert pictures to make the documents more informative and lively. But the pictures are not always suitable from the beginning. If you aren’t going to use any of the graphics processing tools on the market, you can turn to Office itself which has some basic functions […]
-
How to Enter the Same Data in Non-Adjacent Cells in Excel
It’s not difficult to autofill multiple cells with the same data or text. But most of the existing methods require these cells to be continuous. In fact, entering the same data in non-adjacent cells is probably more common in practical terms. If you’ve also been in this situation, try this small trick: First, press the […]
-
How to Insert a Per Mille Sign in Microsoft Excel
Making spreadsheets in Microsoft Excel often involves mathematics, which probably requires you to type percentages and per mille in the cell. So, how to enter them in an Excel sheet? You may already know that a percentage sign (%) can be typed with pressing Shift+5. But the way to insert a per mille sign (‰) […]
-
How to Make a Treemap in Microsoft Excel
Treemap is a simple chart in which you can see the value of each item from the spreadsheet clearly and intuitively. It’s a little bit like pie chart but not that focusing on showing each item’s share of the total. If you’d like to try creating a treemap in your Excel file, here’s the method: […]
-
How to Change the Resolution of Microsoft Excel
A high resolution in Excel will significantly increase the size of the document. Accordingly, you can control the file size by selecting a proper resolution. For example, if you need to send an EXCEL file with mail, free up more space on your hard drive, or reduce its upload / download time on Internet, you […]
-
How to Restore the “New Word Document” in Right Click Menu
After finishing installing Office programs, some people may find there’s no option for creating a new Microsoft Word document in the right click menu. If you’ve even been in this situation as well, I’d like to provide a small tip to solve it. First, press Windows+R and type “regedit” in the text box. Then press […]
-
How to Create a Greeting Card in Microsoft Word
The paper greeting cards is not as common as it used be. People nowadays tend to send e-cards by e-mail, which is convenient, fast and environmentally friendly. There are literally tons of templates for greeting cards can be found on Internet, but they are open for everyone, nothing special. If you want an unique greeting […]
-
How to Quick Insert a Box with Tick or Cross in Microsoft Word
To make the content of your document more intuitive and lively, adding symbols like tick, cross, check box, etc. is an effective method. But what’s the fastest way to insert them? Sure you can copy and paste from Internet If it’s a one-time thing. Otherwise you’d probably better to enter them in Word directly. 1. […]
-
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 […]
