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

  • Simple tutorial to set background image in word2010
    Simple tutorial to set background image in word2010
    Click the [Image Watermark] option. Click the [Select Image] button. Click on the picture you want to set in the browser window that opens. You can set the zoom size and [Erosion] option of the image. If you click to check the [Erosion] option, the image will become lighter. After setting, click the [Apply] button and then close the watermark dialog box.
    Office Software 1116 2024-04-25 19:00:23
  • How does WinRAR software compress files?
    How does WinRAR software compress files?
    WinRAR is a powerful compressed file management tool that supports multiple compressed file formats. So how to use WinRAR to compress files? For those who don’t know, let’s take a look! Compression method: First, install the WinRAR tool, then select the file or folder that needs to be compressed, right-click the mouse, and select [Add to compressed file] in the WinRAR list. After the [Compressed File Name and Parameters] dialog box pops up, we can set different options as needed, such as clicking the [Browse] option to set the save directory, set the compressed file name, select the compressed file format, etc.; if the compressed file is relatively large, you can select [Cut into volumes, size], compress the file into multiple volume files; if you want to protect the security of the file
    Office Software 985 2024-04-25 19:00:10
  • How to set the default font in Excel to Song Dynasty
    How to set the default font in Excel to Song Dynasty
    1. Open Excel and create a new table. 2. Enter the content that needs to be set as a font. 3. Click on the cell that needs to be set, expand the font style, find [Song Dynasty] and click Set. 4. The effect is as shown in the figure. 5. Or select the cell, right-click the mouse and select [Format Cells]. 6. Select [Songti] in the [Font] window, and then click the [OK] button to complete.
    Office Software 651 2024-04-25 18:50:25
  • Specific steps to set print titles in Excel tables
    Specific steps to set print titles in Excel tables
    1. For everyone’s convenience, the content of the first page in Excel is [I am the first page], the second page is [I am the second page], and the screenshot of the original table is shown in the view, and the title is [I am the title]. 2. Before the modification, the preview title was evenly distributed between the two tables. 3. After that, we need to make settings. First, we need to modify the printing area. Exclude the original title from the printing area. The specific setting method is: select all print areas except the title - page layout - print area - set print area. 4. After the settings are completed, preview again. At this time, there will be no title. Select again: Page Layout—Print Title—Page/Header—Custom Header. 5. Enter the custom header. The title is divided into left, center and right. Generally, the title is centered. Here I take the center as an example.
    Office Software 1169 2024-04-25 18:28:05
  • How to add artistic effects to Chinese text in WPS Office 2016
    How to add artistic effects to Chinese text in WPS Office 2016
    1. In the newly created document, select [Insert]---------[WordArt] on the toolbar. click to enter. There are many styles of word art, just choose one at will. 2. After entering, a text input box will be displayed, enter your own text, and a [Text Tool] will appear on the toolbar, where there are detailed settings for text fill, text outline, and text effects. 3. In the more settings in WordArt, after clicking Confirm, you can see the [Properties] on the right, the [Shadow] color, size, distance, angle and other settings for the text effect. 4. In the text direction of word art, you can change whether the font is vertical or horizontal. 5. To set the text effect, you can choose directly from the options on the toolbar, or you can choose from the properties on the right. It depends on what you are used to
    Office Software 1029 2024-04-25 18:20:15
  • Steps to add arrow symbols to word 2010 formulas
    Steps to add arrow symbols to word 2010 formulas
    Open the word2010 document window, click the formula to which you need to add an arrow symbol to put it in the editing state, position the insertion bar cursor at the target position, and click the [Other] button in the [Symbol] group of the [Formula Tools/Design] ribbon Open the Symbols panel and click the drop-down triangle button at the top. Select the [Arrow] option in the open drop-down menu, and select the desired arrow symbol in the opened arrow symbol panel.
    Office Software 1098 2024-04-25 18:10:19
  • How to set the number of digits in Excel cells to be fixed within a range_How to set the number of digits to be fixed within a range in Excel
    How to set the number of digits in Excel cells to be fixed within a range_How to set the number of digits to be fixed within a range in Excel
    1. Select the cell, select Data - Data Validity - Data Validity in the menu bar at the top, and an edit box will pop up. 2. In the edit box, select Settings. In the validity condition, select [Text Length] in the [Allow] column, and select [Data] in the [Data] column as needed. If you want to be between certain digits, choose between; if you want a fixed number of digits, choose equal to. 3. Here is an example. If you are entering a mobile phone number, you are required to enter 13 digits. After setting this option, don’t rush to click OK. 4. The next step needs to be taken. Select Error Warning in the menu bar and set the warning message to ensure that the system prompts when inputting inconsistent data. As for the settings of style [, title], error message [, etc.], they can be
    Office Software 608 2024-04-25 18:01:29
  • How to handle error 1004 when running Excel macro
    How to handle error 1004 when running Excel macro
    After running Excel, click the [Macro] option in the Tools tab, and then select the [Security] option! After opening the security settings interface, lower all security levels and use the developer to leave them blank. If this error is also prompted when creating a new document while using Excel, then we can click the [VB Editor] option in the [Macro] tab under the Advanced tab! Method 3: Some users use some wrong codes or formulas during use. In this case, 1004 error code will also appear. At this point we need to check all codes and formulas!
    Office Software 874 2024-04-25 17:46:21
  • How to use Boolean operations in PPT_Operation content of Boolean operations in PPT
    How to use Boolean operations in PPT_Operation content of Boolean operations in PPT
    1. Open the [Home] tab and draw a shape you like. 2. As shown in the picture, the editor drew two shapes. Here I choose an object at random. 3. Click the Format tab at this time, and you can see [Merge Shapes] below it. In fact, this is a Boolean operation. 4. But everyone will find that this one is gray, which means it is unavailable. What is the reason? In fact, the editor just selected one object. If you select multiple objects, you can use it. For operation, there must be at least two objects. 5. There are five operations for merging shapes, which are actually similar to addition and subtraction in PS or CAD. 6. Look at the effect of the combination. We can see that two objects change into one object. Equivalent to addition. 7. You can see that the combined functions intersect.
    Office Software 545 2024-04-25 17:40:40
  • 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 1217 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 1222 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 1038 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 1226 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 947 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 831 2024-04-25 17:13:37

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