Supposing you have a range of data you want to circle some values which don’t meet your condition, in Excel, you can use Data Validation feature to create rules for selected data range, and then apply Circle Invalid Data function to circle all the data beyond your criterion. Please read this article to know more
How to enable the “Keep Format Tracking” feature in Word Steps: 1. Open a Word 2.Click on File 3.Click on Option 4. This time, the “Word Options” dialog box of the workbook will pop up. 5.Click on Advance 6. In the right pane of the Advanced tab, find the Keep Root Tracking feature in
In certain case, you may want to add the plus sign + in front of positive numbers, if you type the plus sign before the number directly, the plus sign will not display. In Excel, you can convert the format cell to add the plus sign to multiple positive numbers. Please read this article to
How to make a quick recovery card in word Steps: 1. First, we open the word on our computer; 2. Then we click on the file; 3. After that we click on New; 4. Then we click on the card; 5. After that we click on the early recovery card; 6. Then we click
This tip shows how to insert an equation for example, one of De Morgan’s law. To add operators of Boolean algebra, do the following: 1. Create your own equation. Under Equation Tools, on the Design tab, in the Structures group, click the Accent button: 2. In the Accent list choose Bar: 3. In the box:
Tips for setting horizontal lines to text in Word Steps: 1. First enter the “header settings state”; 2. Click “Start” – “Body Status” as shown in the figure; 3. You can complete the horizontal line to the text
Tips for replacing text with images in Word Steps: 1. First open the document that needs to be replaced; 2. Then copy the required picture; 3. Ctrl+H quickly calls up the “Replace” dialog box, input the content as shown; 4. You can finish replacing the text with a picture.
This article introduces how to know the number of characters in excel. Steps: 1.we can enter “=len(text)” to know the number 2.if you want to know more, you can drag it 3.if you want to know all numbers, you can click autosum 4.you can also enter the sum formula 5.you can also enter =SUMPRODUCT(LEN(number))
This article introduces how to draw clustered bar chart in excel. Steps: 1.open the document 2.click insert 3.choose data 4.find chart 5.choose statistic chart 6.choose clustered bar chart 7.we can choose data 8.you can change data 9.then you will get it
How to make entry-subtitle animation in PPT Steps: 1. Open the PPT and select the object to be set into the animation, such as text, shape, picture, table, etc., here choose to insert text. 2. Click the Animation tab and click the Add Animation button in the Advanced Animations group. 3. In the pop-up