归档: Cordelia
-
4 Methods to Go to a Specific Place in Word Document
In a rather long Word document, it can be very time-consuming to keep scrolling down till find a specific part. Can Word just list these different parts out so that we can jump to a specific place within one or two clicks? You might think of the Bookmark feature immediately. In fact, there’re several tips […]
-
How to Sum Multiple Excel Tables Across Sheets
It’s common to input data in different Excel spreadsheets by different people and sum them later. But as you know, if you copy a column of data and copy them into another table, the existing data will be overwritten. Is there a way to sum the data across multiple Excel tables in different sheets? How […]
-
3 Methods to Insert Approximately Equal Symbol in Word
When writing in Word, you may need to insert some mathematical symbols like approximately equal symbol to the document every now and then. But without a button allowing you to directly type it, how to insert an approximately equal symbol in Word? Method 1: Insert Approximately Equal Symbol 1. Open the Word document and switch […]
-
How to Display Numbers as Asterisks in Excel Cells
When you log in some software, the password you entered will be displayed as asterisk to protect your privacy. In Excel, you can also achieve this effect to prevent some important data from being peeked by others. So how to display number as asterisks in Excel cells? It’s a very simple trick. You just need […]
-
How to Process Data with Units Using Functions in Excel
Some people tend to input the data with units into Excel spreadsheet considering it will be more clear and intuitive. But unfortunately, the data with manually entered units can’t be calculated correctly with Excel functions. It means you can only do the summation or subtraction manually as well. To avoid this situation and use functions […]
-
How to Use Function Keys F1 to F12 in Windows and Office
You may already know pressing [F5] key in Windows system can refresh the current page, and pressing [F11] can enable the full screen mode. But do you know the specific functions of all the keys from F1~F12? They do have different functions in Windows system (like the desktop, system folders, browsers, etc.) and Microsoft Office […]
-
How to Generate Dummy Text in Word Document
Before writing in Word, you may be used to set the format and page layout at first. But without an ensemble preview, you can hardly know how it looks like in the actual document. In fact, you can generate some random dummy text in Word with random functions to check the typesetting effect. 1. Generate […]
-
How to Sort Data by Multiple Columns in Microsoft Excel
An Excel spreadsheet is often composed of multiple columns with various data, and they are all related in some way. You probably need to take more than one columns into consideration while sorting. So how to do it? The Sort feature in Excel allows you to add multiple levels as the criteria to sort the […]
-
How to Paste Text in Word Without Format
When you copy some texts from Internet and want to paste them in Word document, the format could become a frustrating problem since those sentences from different websites usually come with different formats. To paste text in Word without format, you can try these tips in your document. 1. Paste without Format Select the text […]
-
How to Change and Remove the Background of Word Documents
After a long time writing with Microsoft Word, your eyes may already tired of the default blank page. To refresh yourself , you can insert a picture as the background of Word document. How to Change Background Color of Word 1. Go to Design tab. 2. Click Page Color in Page Background section. 3. You […]