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：
-
- How to insert rows every two rows in Excel
- The first is to enter 1 in C3 and select two columns including 1 downwards. Drag the mouse down and release when there is no content. Press and hold the shortcut key F5 to pop up the positioning dialog box, select the positioning conditions, and confirm the constants. Find that 1-6 are selected, right-click-Insert-Entire row, OK. Delete columns 1-6 and find that one row is successfully inserted every two rows.
- Office Software 1167 2024-04-25 12:01:06
-
- How to set up automatic calculation in WPS2019_How to set up automatic calculation in WPS2019
- Step 1: First select the table where you want to display the calculation results, as shown in the figure. Step 2: Then right-click the table and click [Format Cells], as shown in the figure. Step 3: Then select [General] or [Value] in the category under [Number], as shown in the figure. Step 4: Enter [=EVALUATE()] in the table where the results are to be displayed. The content in the brackets is the cell where the calculation is located. For example, the editor’s calculation is in A4, which is =EVALUATE(A4), as shown in the figure. Step 5: Finally, click the enter key, and the result of the formula will be automatically calculated, as shown in the figure.
- Office Software 766 2024-04-25 12:00:28
-
- How to draw a gradient arc in wps_How to draw a gradient arc in wps
- 1. After opening the interface, click the shape option in the insert menu and select the ellipse style. 2. Drag the mouse to draw a 15*15 cm circle, change the color fill to orange, and set the no-outline effect. 3. Copy the circle. And modify the height and width to 16.5*16.5 cm 4. Open the object properties panel of the copied circle, modify the no fill and gradient line effects 5. Adjust the gradient color, position and transparency of the arc according to the parameters shown in the figure 6. Finally: Align the arc and circle settings in the center to complete the arc drawing of the circle.
- Office Software 802 2024-04-25 12:00:15
-
- How to cancel paragraph marks in Word document
- 1. How to cancel the document with paragraph marks displayed in this way. 2. Click the office icon in the upper left corner of the document. 3. Click [Word Options] in the drop-down item. 4. Click [Display] on the left. 5. Uncheck the box before [Paragraph Mark]. 6. Click [OK]. 7. The paragraph marks in the document will no longer be displayed.
- Office Software 1201 2024-04-25 12:00:06
-
- How to insert a donut chart in WPS2019_How to insert a donut chart in WPS2019
- First, we open our computer, and then we open wps2019 text. Then we click insert. Then we click on the chart. Then we click on the pie chart. Then we click on the donut chart. Then we can see a donut chart in the document. Then we click on the empty space. The result is as shown in the figure, so we have inserted a donut chart.
- Office Software 1047 2024-04-25 11:58:11
-
- How to compress PDF file size with WPS_WPS compress PDF file size tutorial
- Step 1: First we need to open the PDF document, and then click the [File] option on the upper left side, as shown in the figure. Step 2: Then, in the opened sub-options, find the option [Reduce PDF Size] and click on this option with the left mouse button, as shown in the figure. Step 3: At this time, on the page, we can see the size of our original document and the size after standard quality compression, which is currently 1.06M, as shown in the figure. Step 4: If we want to compress it to within 1M, we will adjust the quality and check [Medium Quality], then our compressed size will be within 1M, as shown in the figure. Step 5: If you still want to reduce the memory, just check the lower [Low Quality]. Step 6: After setting up, click
- Office Software 905 2024-04-25 11:55:05
-
- How to set up segmented display of mobile phone numbers in Excel
- 1. Create a new Excel table. 2. Enter the content that needs to be set. 3. Select the cells that need to be set, right-click the mouse and select [Format Cells]. 4. Then a settings window will pop up. 5. Then select [Custom], enter [000-0000-0000] the style to be segmented in the type, and then click the [OK] button to set up the city. 6. The effect is as shown in the figure, the number has been displayed in segments.
- Office Software 752 2024-04-25 11:52:56
-
- How to display Word tables in ppt_How to insert Word tables in ppt
- 1. In presentation editing mode, click the [Insert] tab on the ribbon. 2. Click the [Object] button in the [Text] group. In the [Insert] object dialog box, click the [Create from file] radio button, then click the [Browse] button to find and select the Word document containing the table, and click the [Open] button. The file selected at this time will be displayed in the text box below [File], as shown in Figure 1. Tip: By default, the file is fully inserted into the current presentation. If you want the inserted table to change together with the table in the original file, select the [Link] check box in the above dialog box. 4. Click the [OK] button. At this point, the Word table is inserted into the current presentation, as shown in Figure 2. 5. If you want to be in P
- Office Software 802 2024-04-25 11:52:05
-
- How to set custom shortcut keys for symbols in word2010
- In the word document, place the mouse at the point where you want to insert the dot and click, open the [Insert] tab, click the [Symbol] button in the symbol bar, some common symbols will be listed here, if necessary, click to select That’s it. If there is no dot you need here, please click the [Other Symbols] link at the bottom of the menu. After the symbol dialog window pops up, select an appropriate symbol type in the [Subset] drop-down menu. Here, we choose [Generalized Punctuation] as an example. After selecting the dot icon, click the [Insert] button. (Don’t close the symbol dialog window yet) PS: There are usually two types of dialog windows, modal and non-modal dialog windows. Modal dialog windows are windows that must be closed before you can perform other activities, while non-modal windows allow you to continue working while the dialog window is still open.
- Office Software 1075 2024-04-25 11:50:28
-
- The specific method of using Excel's replace function to sensitize people's names
- 1. Organize the original excel list information, such as name information or bank card number information. 2. Our requirement is to process the name column in excel so that only the first character of the name is retained, and all subsequent names are replaced with *, so enter =REPLACE(B19,2,2 in cell C2 ,"**"), the replacement result shows Li**. Double-click the lower right corner of C2 and all values in column B will be replaced. 3. If you feel that you do not want to display ** when the name contains two characters, you can simply optimize the function and simply distinguish between three characters and two characters. =IF(LEN(B2)=3,REPLACE(B2,2,2,"**"),REPLACE(B2,2,1,"*")). 4. to
- Office Software 1075 2024-04-25 11:50:18
-
- Detailed operation of creating formulas containing matrices in word2010
- Step 1, open the word2010 document window and switch to the [Insert] ribbon. Click the [Formula] button in the [Symbol] group (not the [Formula] drop-down triangle button). In step 2, create a blank formula frame in the word2010 document. In the [Formula Tools/Design] ribbon, click [ [Matrix] button in the Structure] group. The open matrix structure list includes types such as [empty matrix], [point], [unit matrix], [bracket matrix] and [sparse matrix]. Select the appropriate matrix structure form. Step 3, in the blank formula frame A matrix structure will be added, just click on the matrix placeholder box and enter specific values.
- Office Software 684 2024-04-25 11:49:27
-
- How to use WPS record sheet
- Open wps form. Import the table data that needs to be recorded. Click [Data] in the menu bar. Then use the mouse to select the required table data. Then click the Record Order button on the toolbar. Then a record sheet window will pop up. This way you can clearly see the data for each item. Want to change the data in the table. Just enter the changed data in the record sheet and press the Enter key. If you want to view the data. Click the [Next] button in the window to view the data corresponding to each item. Or click the [Condition] button. Then enter the data for one of the items and press the Enter key to find other corresponding data.
- Office Software 830 2024-04-25 11:46:33
-
- Steps to delete forced line breaks in Excel in batches
- First, let’s talk about what a forced line break is, as shown in the picture: Sometimes the text entered in the cell is too long, which affects the beauty and browsing of the table, so it is necessary to force a line break. ALT+Enter at the position where the line break is required can force a line break. Let's take a look at how to delete forced line breaks in EXCEL in batches. CTRL+H opens the [Replace] dialog box. After holding down ALT in the search content, use the small keyboard to enter 10 and fill in nothing in the [Replace with] dialog box. Confirm directly. Take another look at the replacement effect. Are all forced line breaks removed?
- Office Software 527 2024-04-25 11:46:05
-
- How to add page breaks to word documents
- 1. Open the document, position the cursor where you want to insert the page break, and click the page layout menu to enter. 2. Click Page Settings | Separator, and select Section Break | Next Page from the pop-up options. 3. In this way, the content behind the cursor and the content before the cursor belong to two different sections.
- Office Software 438 2024-04-25 11:43:35
-
- How to hide pictures and tables together in Excel
- 1. Hidden rows or columns by default 1. Select the column where the picture is located, right-click and select Hide: 2. As shown in the figure, after the column is hidden, the picture is not hidden, but moved to the right to the next column: 2. How to hide cells and pictures at the same time 1. Select the picture, press the F5 key on the keyboard, and click on the positioning criteria: 2. Select the object and click OK to select all objects with the same format as the selected picture: 3. Right-click For any picture, select the size and attributes: 4. Click the attribute box on the right, select the size and position to change with the cell: 5. Select the row or column where the table is located, right-click, and select Hide: 6. As shown in the figure, The image is now hidden along with the column:
- Office Software 712 2024-04-25 11:43:21
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
