归档： Cordelia
-
Tips to Solve Common Problems of Auto Numbering in Word
The auto numbering in Word can help you to create a numbered list or add sequence to existing paragraphs automatically, which is very time-saving. But in practice, there’re some frequently happened problems can cause your inconvenience. Therefore, I’d like to share some useful tips to solve these problems in auto numbering. 1. How to Stop […]
-
How to Merge Multiple Tables from Different Excel Sheets
Sometimes you may have the need to create a comprehensive Excel document whose data comes from different files or even files edited by different people. It’s feasible to copy & paste the data manually if it isn’t too much. Otherwise you can try the Consolidate feature to let Excel do most of the work and […]
-
How to Underline Specific Text Automatically in Word Document
When editing some important files or contracts in Word, you probably need to underline a word or a sentence for many times in the same document, which is very time-consuming and easy to miss. So, is there a way to underline all the specific text in batch automatically? Fortunately, the feature Find and Replace in […]
-
how to Quick Capitalize the First Letter or Each Word in Excel
When entering some specific information like company names or employee names into an Excel sheet, you may want to capitalize the first letter of each word in each cell. But instead of changing the text case one by one, can you do it in batch? 1. First of all, you can create a new column […]
-
How to Display Numbers in Excel as Cell Phone Numbers
In Excel spreadsheet, the long numbers are often displayed in segments, which is not only easy to view, but also more standardized. So how to segment long numbers in Excel cells and make them displayed as cell phone numbers? You can solve this kind of problem simply by change the setting in Format Cells. 1. […]
-
How to Insert Data Bars or Directional Icons to Excel Cells
Excel can not only process data quickly, but also display data in various ways intuitively. For example, you can insert data bars or directional icons to show numerical value of each cell in Excel. And the method is very simple. How to Insert Data Bars 1. Select the cells you want to add data bars. […]
-
3 Methods to Insert Circled Numbers and Letters in Word
Sometimes you may need to insert numbers or letters with circles in Word document, but you can’t type them directly or copy them from Internet every time. So how to insert circled numbers and letters in Word exactly? To answer this question, I’ll share the detailed steps in the post. You can have a try […]
-
How to Remove All the Wavy Lines Under Text in Word
When editing documents in Word, you must have seen some colorful wavy lines under the text, which make the whole layout untidy. These wavy lines are actually informing you that there’s something wrong with your words or sentences. It’s automatic but not always accurate. So, how to remove all these wavy lines in Word? 1. […]
-
How to Cut and Paste Discontinuous Text and Images in Word
In Microsoft Word, you can only cut and paste contiguous text and images with the ordinary method. If you have multiple discontinuous items in the document to deal with, and want to cut& paste them at once, try using these shortcuts: [Ctrl+F3]: cut [Ctrl+Shift+F3]: paste The detailed steps are as below: 1.Select the first item […]
-
How to Circle All the Invalid Data in Excel at Once
It’s not surprising that there’s some invalid data in an large Excel spreadsheet. If you want to screen out all of them at once, the best idea is to set Data Validation in Excel, and then choose to Circle Invalid Data. Here’re the detailed steps: 1.Select the cells. 2.Go to Data tab. 3.Click Data Validation […]
