current location：Home > Technical Articles > Software Tutorial > Office Software
- Direction：
- All web3.0 Backend Development Web Front-end Database Operation and Maintenance Development Tools PHP Framework Daily Programming WeChat Applet Common Problem Other Tech CMS Tutorial Java System Tutorial Computer Tutorials Hardware Tutorial Mobile Tutorial Software Tutorial Mobile Game Tutorial
- Classify：
-
- Steps to set drop-down options in WPS Office 2016 table
- First create a new excel table. After saving the excel, click the [Insert] option above. At this time, you will see an icon similar to a drop-down list in the toolbar on the right, called [Combo Box]. Click this combo box icon. Then hold down the left mouse button and drag it in excel. When you let go, you will see that a drop-down list box has been drawn. At this time, the drop-down list is still empty. We fill in a column of text elsewhere, and this text will serve as the content options of the drop-down list. Then right-click on the drop-down list and select the [Format Object] option. Then you will see the data source option in the pop-up window. Click the icon behind it, and then a long box will pop up. After the method of making drop-down menu list in wps table
- Office Software 1247 2024-04-25 19:50:16
-
- Specific steps to set up repeated automatic prompts in Excel
- First we select the entire column or row that we do not want to enter repeatedly. Then click [Data Validity] in the [Data] column to ensure the [Data Validity] in this column. The version above 2013 is called [Data Validation]. In the pop-up data validity window, set [Allow] to [Custom], and then enter the formula =COUNTIF(A:A,A1)=1 in the formula below. The same content in column A of the table is only allowed to appear once. Then enter the information to be prompted in [Error Warning], such as [Duplicate content! 】. After finally clicking OK, the data verification in the list is set up. Next time you enter duplicate content, you will be prompted for duplicate information!
- Office Software 928 2024-04-25 19:40:14
-
- 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 1138 2024-04-25 19:00:23
-
- 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 1016 2024-04-25 19:00:10
-
- 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 782 2024-04-25 18:50:25
-
- 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 1246 2024-04-25 18:28:05
-
- 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 1059 2024-04-25 18:20:15
-
- 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 1143 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
- 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 665 2024-04-25 18:01:29
-
- 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 986 2024-04-25 17:46:21
-
- 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 638 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
- 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 1333 2024-04-25 17:34:38
-
- 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 1258 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
- 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 1134 2024-04-25 17:31:05
-
- 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 1266 2024-04-25 17:25:27
Recommended Articles
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.
Player special effects
2024-02-29
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
