current location:Home > Technical Articles > Software Tutorial > Office Software

  • How to make creative geometric figure animations in PPT_Steps and methods to make creative geometric figure animations in PPT
    How to make creative geometric figure animations in PPT_Steps and methods to make creative geometric figure animations in PPT
    1. Click [Insert]-[Shape]-[Triangle]-press the shift key to draw a triangle. 2. Right-click the triangle-Format Shape-No Fill-Gradient Line-Choose your favorite color in the gradient aperture-Adjust the aperture position. 3. Click islide-design layout-circular layout. 4. Adjust the quantity to: 35 - Starting angle: around 66.7 - Layout radius: around 19.8 - Rotation mode: automatic rotation. 5. Select all shapes-Animation-Add Animation-Gyro. 6. Click the preview in the lower right corner to see the effect.
    Office Software 1411 2024-04-25 17:34:38
  • How to add a data identification circle in Excel_How to add a data identification circle in Excel
    How to add a data identification circle in Excel_How to add a data identification circle in Excel
    First, open an Excel table. We found that the table contains the scores of each subject of Class 1 of the third grade. Here we need to find the scores greater than 110 points: select all cells containing scores, click [Data] on the toolbar, and select the drop-down menu Select [Validity] in the secondary menu, or select [Validity] in the secondary menu: In the pop-up data validity dialog box, allow one column to enter [integer], select [less than or equal to] for the data list, and select [110] for the maximum value , click OK: Then repeatedly click [Validity] under the [Data] option, and then select [Circle Invalid Data] in the secondary menu: At this time, all data greater than 110 are marked:
    Office Software 1279 2024-04-25 17:34:14
  • How to change the mouse pointer in PPT - Steps to change the mouse pointer into a brush shape in PPT slides
    How to change the mouse pointer in PPT - Steps to change the mouse pointer into a brush shape in PPT slides
    1. Open a PPT and show it. 2. During the screening process, right-click the mouse and click [Pointer Options]. 3. In the pointer options, the default is the mouse arrow, we just click it to become [Brush]. 4. After completion, we can check and click on the PPT. 5. Of course, you can also change the color of the brush. 6. As shown in the picture, replace it with a yellow paintbrush.
    Office Software 1178 2024-04-25 17:31:05
  • How to freeze columns in WPS table_Tutorial on freezing columns in WPS table
    How to freeze columns in WPS table_Tutorial on freezing columns in WPS table
    Step 1: First open the WPS form, as shown in the figure below. Step 2: Then in the edited form, select the columns you want to freeze, as shown in the figure below. Step 3: Then click the [View] button in the menu bar, and click [Freeze Window] in the view bar tool, as shown in the figure below. Step 4: Return to our operation interface, we can see the effect after setting, as shown in the figure below.
    Office Software 1277 2024-04-25 17:25:27
  • Introduction to how to create a check button in Excel
    Introduction to how to create a check button in Excel
    1. Open an Excel table and select the entire table to set the row height. 2. Right-click the option bar and select [Customize Ribbon]. 3. Find the [Development Tools] option and select it, then click OK to complete the settings. 4. Click [Development Tools] and select the boxed check icon in [Insert]. 5. Click on any position and a check button will appear. Modify the text to what you need. When the mouse turns into a cross shape, you can click the left button of the mouse and drag the button to the position where you want to place it. 6. Click the box to check the content, and click it again to cancel the check.
    Office Software 1203 2024-04-25 17:25:19
  • How to batch input serial numbers with brackets in Excel_Sharing tips for batch inputting serial numbers with brackets in Excel
    How to batch input serial numbers with brackets in Excel_Sharing tips for batch inputting serial numbers with brackets in Excel
    First select the cell below the serial number, right-click the mouse to set the cell format: click the number, then set it to text format, click OK: enter (1) in the first cell, hit the Enter key, a bracketed The serial number is born: then drag the small dot in the lower right corner to quickly fill it in and then fill it in sequence: This is done:
    Office Software 895 2024-04-25 17:13:37
  • Tips to solve the problem of being unable to input Chinese characters when using Word
    Tips to solve the problem of being unable to input Chinese characters when using Word
    In fact, this is a setting problem of word2007. The solution tips are as follows: 1. Open a word text, select the circle in the upper left corner, and click word options. 2. After the options are opened, select [Advanced], and then check [Input method is active]. Remove the hook.
    Office Software 901 2024-04-25 16:46:30
  • How to display numbers on the bars in ppt histogram_How to display numbers on the bars in ppt histogram
    How to display numbers on the bars in ppt histogram_How to display numbers on the bars in ppt histogram
    Step 1: Open PPT, insert the histogram and click the chart element on the right. Step 2: Check the data label to display numbers on the bar.
    Office Software 1698 2024-04-25 16:43:20
  • Detailed steps for inserting steel grade symbols in word
    Detailed steps for inserting steel grade symbols in word
    After the steel symbol SJQY font is installed, it can be used. Open the word document, click [Insert], and click [Symbol] (Note: This is word2013, the operations of word2007 and word2010 are basically the same, and the operations of word2003 are similar). Under the [Symbols] column, click [Other Symbols]. Enter the symbol insertion column, enter [SJQY] in the box behind the symbol, and click [Insert]. At this time, the required steel grade symbol appears. Select a grade symbol and click [Insert]. If you need to insert all the grade symbols here, click to select one, then click [Insert]. After clicking, click [Close] to close the insertion window. At this time, insert the steel bar grade you need.
    Office Software 1180 2024-04-25 16:40:19
  • How to quickly align words in Word_How to quickly align multiple rows of text in Word
    How to quickly align words in Word_How to quickly align multiple rows of text in Word
    Let's take the table below as an example. We want to align the text below with the first line. 1. It’s very simple. We first select the text to be aligned. 2. Check the ruler in the [View] menu, and the ruler next to the page will be displayed. 3. Then we use the left mouse button to click on the ruler to locate the position to be aligned. 4. Finally, we position the cursor in front of the text to be aligned and press the Tab key to easily align the text. If you want to align the text of these names, it is also very simple. 1. We first hold down the ALT key to select the name text, and then click [Adjust Width] in the menu above. 2. Change the character width to the maximum character width of 5, click OK, and the name text will be aligned.
    Office Software 511 2024-04-25 16:37:10
  • PPT multi-paragraph text layout operation tutorial
    PPT multi-paragraph text layout operation tutorial
    First, select the text box of the multi-paragraph text, position the mouse before the paragraph, and click [Raise List Level] above to grade the paragraphs. Then select the text box, click [Convert to SmartArt] - [Other SmartArt Graphics] in the [Start] bar above, select [Vertical Box List] in [List], and click OK. Finally, the text is formatted, and then you can right-click on it to select the style, color and layout, and beautify it.
    Office Software 1210 2024-04-25 16:31:31
  • How to quickly delete English in batches of word documents and keep only Chinese
    How to quickly delete English in batches of word documents and keep only Chinese
    Open the word document that needs to be processed, and you can see that the document contains Chinese and English. Our purpose is to delete all English. Click [Start] - [Edit] - [Replace] in the word menu bar, or directly press the ctrl+f shortcut key to call it up. After calling up the [Find and Replace] window, click [More], and in the new options, select the [Any Letter] option in [Special Format], so that] the search content [will appear in the selection box] and any letter [corresponding to The [^$[ character. [Replace with] checkbox keeps the spaces and no content (because our purpose is to delete the English content, and the spaces mean no content), and then click Replace All. After replacing them all, all English letters in the word document will be deleted, and the final effect is as shown below.
    Office Software 903 2024-04-25 16:28:17
  • How to replace string in Excel table
    How to replace string in Excel table
    1. If you want to generate the required format, you can use the replacement function (REPLACE), the string length function (LEN), and the generate repeated text function (REPT). 2. Description of the function formulas that need to be used. The function to be replaced, the function formula is: REPLACE (the string text to be replaced, starting from which character, the number in the string to be replaced, the new string). (2) The function to calculate the length of a string, the function formula is: LEN (referencing the string in the cell) (3) The text function that is repeatedly displayed, the function formula is: REPT (the string to be generated, the number to be generated) 3 .Open the Excel table and enter the formula =REPLACE($A2,2,LEN($
    Office Software 1221 2024-04-25 16:28:09
  • PPT draws the graphic and text operation process of potted flowers and flowers
    PPT draws the graphic and text operation process of potted flowers and flowers
    First insert a text box in the PPT - enter the title name of the first shape: regular straight line. Click Insert - Shape - select rectangle, triangle, parallelogram, rhombus, hexagon, etc., which are regular shapes formed by straight lines. Create a new slide titled: Regular Curved Shape - and then select the Insert Shape: Oval, Heart, Teardrop, Crescent, etc. Create a new slide and classify the shapes as: Irregular Straight Lines - Then click Insert - Shape - Select Polygon to draw a shape composed of any irregular straight lines. Create a new slideshow of [Irregular Curve Shape] using the same method - click Insert - Select Curve - Freely draw irregular curve shapes. Finally, insert circles, rectangles, irregular curves and trapezoids to form
    Office Software 660 2024-04-25 16:22:06
  • Steps for operating the word space interval size and the number of characters occupied by each space
    Steps for operating the word space interval size and the number of characters occupied by each space
    The so-called space interval size refers to the number of characters occupied by spaces. Simply put, how far does the cursor move every time the space bar is pressed in word! Under normal circumstances, under the default condition of Word, if you press the space bar once, the space between English words will account for 0.5 bytes, while the spaces between Chinese characters will account for 1 byte. One byte is the distance of half a Chinese character and the distance of one English character. If we do not want to use the default space interval, we can set it in word so that the spaces between Chinese, English or Chinese and English occupy the same distance. The following is the method, please read carefully. As shown in the picture, find the menu [Format] → [Paragraph]. A dialog box as shown in the figure will pop up. In the picture above, switch to [Chinese Format], then find [Word
    Office Software 625 2024-04-25 16:19:29

Tool Recommendations

jQuery enterprise message form contact code

jQuery enterprise message form contact code is a simple and practical enterprise message form and contact us introduction page code.
form button
2024-02-29

HTML5 MP3 music box playback effects

HTML5 MP3 music box playback special effect is an mp3 music player based on HTML5 css3 to create cute music box emoticons and click the switch button.

HTML5 cool particle animation navigation menu special effects

HTML5 cool particle animation navigation menu special effect is a special effect that changes color when the navigation menu is hovered by the mouse.
Menu navigation
2024-02-29

jQuery visual form drag and drop editing code

jQuery visual form drag and drop editing code is a visual form based on jQuery and bootstrap framework.
form button
2024-02-29

Organic fruit and vegetable supplier web template Bootstrap5

An organic fruit and vegetable supplier web template-Bootstrap5
Bootstrap template
2023-02-03

Bootstrap3 multifunctional data information background management responsive web page template-Novus

Bootstrap3 multifunctional data information background management responsive web page template-Novus
backend template
2023-02-02

Real estate resource service platform web page template Bootstrap5

Real estate resource service platform web page template Bootstrap5
Bootstrap template
2023-02-02

Simple resume information web template Bootstrap4

Simple resume information web template Bootstrap4
Bootstrap template
2023-02-02

Cute summer elements vector material (EPS PNG)

This is a cute summer element vector material, including the sun, sun hat, coconut tree, bikini, airplane, watermelon, ice cream, ice cream, cold drink, swimming ring, flip-flops, pineapple, conch, shell, starfish, crab, Lemons, sunscreen, sunglasses, etc., the materials are provided in EPS and PNG formats, including JPG previews.
PNG material
2024-05-09

Four red 2023 graduation badges vector material (AI EPS PNG)

This is a red 2023 graduation badge vector material, four in total, available in AI, EPS and PNG formats, including JPG preview.
PNG material
2024-02-29

Singing bird and cart filled with flowers design spring banner vector material (AI EPS)

This is a spring banner vector material designed with singing birds and a cart full of flowers. It is available in AI and EPS formats, including JPG preview.
banner picture
2024-02-29

Golden graduation cap vector material (EPS PNG)

This is a golden graduation cap vector material, available in EPS and PNG formats, including JPG preview.
PNG material
2024-02-27

Home Decor Cleaning and Repair Service Company Website Template

Home Decoration Cleaning and Maintenance Service Company Website Template is a website template download suitable for promotional websites that provide home decoration, cleaning, maintenance and other service organizations. Tip: This template calls the Google font library, and the page may open slowly.
Front-end template
2024-05-09

Fresh color personal resume guide page template

Fresh color matching personal job application resume guide page template is a personal job search resume work display guide page web template download suitable for fresh color matching style. Tip: This template calls the Google font library, and the page may open slowly.
Front-end template
2024-02-29

Designer Creative Job Resume Web Template

Designer Creative Job Resume Web Template is a downloadable web template for personal job resume display suitable for various designer positions. Tip: This template calls the Google font library, and the page may open slowly.
Front-end template
2024-02-28

Modern engineering construction company website template

The modern engineering and construction company website template is a downloadable website template suitable for promotion of the engineering and construction service industry. Tip: This template calls the Google font library, and the page may open slowly.
Front-end template
2024-02-28