归档： Cordelia
-
How to Sort Excel Cells by the Number of Characters
If most of the data in an Excel spreadsheet is text, and each cell has a different length of content, it may look untidy on the whole. For this situation, you can sort these cells by the number of characters. But as you know, there’s no such an existing sorting rule to use directly. Before […]
-
How to Multiply Numbers in Microsoft Excel Quickly
Multiplication and division are very common in mathematics as well as in Excel calculations. To multiply numbers in Excel, there’re 2 simple ways you can try. I’ll share the detailed steps in this post. Method 1: Using Formula to Multiply 1. Click the cell for outputting the calculation result. 2. Input the formula directly: =A2*B2 […]
-
How to Annotate Specific Words or Sentences in MS Word
Sometimes when you edit a document in Word, you may need to annotate a specific word, sentence or paragraph inside the page footer. But apparently you can’t achieve the ideal effect by typing the annotation directly. So, how to annotate a specific text in Word correctly? 1. First, open the Word document and select the […]
-
How to Create a Clipping Line in Microsoft Word
Making some special templates in Word requires you to insert a clipping line, telling others to cut paper along the dotted line with scissors. So, how can we make an iconic clipping line in Word? Before taking action, you should know what a clipping line looks like. It’s usually composed of a dotted line and […]
-
How to Hide and Show Specific Text in Microsoft Word
To prevent the content in Word document from being peeked or tampered, one effective way is to protect it with password. But if you are afraid of forgetting the password in the long run, it’s also feasible to hide the content temporarily. So, how to hide and show the specific text in Word document? 1. […]
-
How to Highlight All the Nonworking Days in Excel Spreadsheet
If you entered a series of dates into Excel spreadsheet, and want to highlight all the nonworking days. Do you have to pick out the weekends manually? In my previous post, I’ve introduced some uses of the powerful Conditional Formatting. It enables you to apply a format to multiple cells that meet the specific criteria. […]
-
How to Customize and Unify the Date Format in Excel Quickly
It’s quite troublesome to enter dates into Excel Spreadsheet with a canonical format manually. But if you don’t unify the format, it will affect the operation with formulas in the sheet. Therefore, I’d like to introduce 2 ways to unify the entered data and display them as the customized format. Method 1: Using Format Cells to […]
-
How to Display the Word or Excel File with Thumbnail in a Folder
A folder full of Word and Excel Files with default icons can be very confusing for you to find a specific one. If you can display them with thumbnail, it’ll be much more intuitive. So, how to save a Word or Excel file with thumbnail, and display the thumbnail in the folder? 1. First, click […]
-
How to Add a Drop-down List in Excel
You must have seen some Excel spreadsheets with drop-down list. It’s quite convenient to select an option from the list instead of typing it by yourself. Therefore, I’d like to share some experiences of creating a drop-down list in Excel. 1. Select the cell you want to add drop-down menu. Click Data Validation in Data […]
-
How to Create and Quote Reusable Text and Picture in Word
When you edit some commercial documents like contracts in Word, there are always some words or sentences appear repeatedly. It’s OK to type them manually for two or three times, but what if they keep repeating in your document? Is there an alternate way to save the reusable text or picture and quote them quickly […]
