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 add borders to tables in PPT2016_How to add borders to tables in PPT2016
- First, we created a sample table in PPT2016. It can be seen that there is no built-in border. We first select the table, click [Table Tools-Design] above, and then you can see the border inside, and click to add the desired border line. If you want to change the color of the border, first click on the pen color next to it and select the desired color there. Then click the border again, select Add Border, and the color of the border line will be changed successfully. At the same time, the thickness of the border line can also be adjusted.
- Office Software 590 2024-04-25 15:10:34
-
- How to deal with problems when the Excel table prompts to send commands to the program
- 1. Determine whether there is a problem with the input method. Uninstall and reinstall the input method. 2. If it still exists, it may be due to table compatibility issues. Click the table shortcut on the desktop---->Properties---->Compatibility. , check the box, if the shortcut has been deleted, it can be found in all programs in the start menu. 3. In addition, there is another possibility that there is a problem with the template table of the form, just find it and delete it. The path is: C:Users currently logged in computer account AppDataRoamingMicrosoftTemplatesNormal.dot, just delete the file directly. If none of the above methods work, you can also try to completely format the computer and reinstall the system.
- Office Software 1065 2024-04-25 15:10:31
-
- How to set anti-white posters in WPS_How to set anti-white posters in WPS
- 1. After opening the interface, insert an autumn scene picture and enter digital text in the lower right corner of the picture 2. Click on the text content, add a white to black gradient fill, and modify the position parameter to 48% 3. Click on the shadow in the text option Effect, select the upper right diagonal offset option 4. Finally, use the same steps to add the autumn English in reverse white to complete the editing and production of the poster.
- Office Software 672 2024-04-25 15:10:23
-
- How to set superscript in WPS2019_How to set superscript in WPS2019
- Step 1: First open WPS2019. In the ribbon, we find text processing and click to open, as shown in the figure below. Step 2: Then find the character superscript and subscript in the drop-down list and click to open, as shown in the figure below. Step 3: On the opened tab, we check Number superscript by character type, and then click OK, as shown in the figure below. Step 4: Finally, we can see that all the numbers in the cells have become superscripts, as shown in the picture below.
- Office Software 473 2024-04-25 15:10:11
-
- Detailed steps to add document separators in Word
- 1. Open a copy of the official document. Click outside the editing area to the left of the document title (click when the mouse changes from "I" to an arrow) to make the title selected. 2. Find "Start" - "Paragraph" - "Side Cabinet" icon (! Small inverted triangle!) - "Border and Shading" Note: Click the small inverted triangle next to "Border". 3. After opening the "Border and Shading" dialog box, 1) select the line type 2) remove the "top, left, and right" borders as shown in the picture, retain the "bottom border", and then press OK. 4. At this time, I found that the line type and color were incorrect. Repeat step 2, open "Border and Shading" and re-select "Line Type Color Width". After selecting, I cannot press "OK" immediately! ! Because at this time, you haven’t told WORD which side you want to change. Tip: Must be applied to
- Office Software 624 2024-04-25 15:01:31
-
- Detailed operation process of batch calculation multiplication in WPS table
- Open the form and enter the required data. For example, C1=A1*B1. Enter [=] in the first cell below [C1] and click to select A1 data. Enter [*] and click to select B1. Press the Enter key on the data, and the results will come out. With so many numbers below, it would be okay to follow the above algorithm one by one, but it would be too troublesome. You can do this, place the mouse at the cell where the result is [39], move the mouse, and drag it to the lower right corner when the mouse changes to +, then pull the mouse down, and the required result will appear. If you are afraid of making mistakes, You can check it out.
- Office Software 764 2024-04-25 15:01:11
-
- How to put Excel charts into Word
- First, let’s demonstrate an error example, which is to directly copy the Excel chart into Word. The consequence of this is that if the chart is enlarged or reduced in Word, the text and graphics in the chart will be squeezed together, which is simply ugly. . The correct method is as follows: First, we copy the chart in Excel using CTRL+C. Then in Word, click [Start]-[Paste]-[Paste Special] and select the paste link [Excel Chart Object]. In this way, a neat Excel chart will be imported into Word, and no matter how you change the size, the data and text inside will be fully displayed. At the same time, if the data in your Excel has been modified, the graph in Word
- Office Software 1003 2024-04-25 15:00:29
-
- Steps to solve the problem that the Excel attendance sheet picture cannot be deleted when the mouse is moved
- 1. As shown in the figure, the picture will move with the click of the mouse. 2. Select the upper left corner of the table as shown in the figure and select the entire table. 3. In the menu bar: Data---Data Validity---Settings---Clear All---OK. If you click on the form again, there will be no pictures.
- Office Software 528 2024-04-25 14:58:21
-
- Graphical tutorial on calculating working days in Excel
- 1. Let’s take the following table as an example. We will first list all the statutory holidays that we will experience, and pay attention to the pure date format. 2. Then enter the function =networkdays in the cell of the working day. What you need to fill in the function is to select the starting date [comma] and select the end date [comma]. Finally, we select all the dates of legal holidays, press F4, and make the address an absolute reference. 3. After filling in, press Enter and the working days will be calculated. But note that this networkdays function only calculates working days with weekends and weekends. If there are odd and weekend holidays, then you need to use the =networkdays.intl( function. The filling method is also the same. After selecting the date, the next step is to judge. like
- Office Software 430 2024-04-25 14:55:33
-
- A detailed introduction to setting the title style of a word document so that it does not change with the text style
- 1. First of all, in the first step, we need to open word and then create a blank document. 2. Then, ask us to enter our text content in the document. 3. After entering the text content, we can see from the text content that the article is divided into three modes: chapter title, section title and body content. Therefore, the chapter title and section title need to be set to the title style. The most convenient, quick and easy way to distinguish is to set the Title 1 style for chapter titles and the Title 2 style for section titles. This will make the division clearer, and the main text will use the main text style. 4. We need to click to modify the style of the text. 5. For example, if we first set the text style content to indent the first line by 2 characters. After setting this
- Office Software 571 2024-04-25 14:55:11
-
- How to create a resume in PDF format in Word
- 1. Open Word and select a template in the [New] interface, or click to search for the template style you want. 2. Select a template style and click the [Create] button. 3. Next, you can fill in your actual information according to the template. Step 2: Convert resume to PDF format 1. After filling in the resume, go to the official website of PDF Quick Convert, click the Download Now button to download and install. Address------------------》PDFkz.com-PDF Quick Transfer-Free Word, Excel, PPT, and picture conversion tool www.pdfkz.com 2. Open the installed software , click to log in to enjoy the free version of conversion. 3. Click to select the [Word to PDF] function. 4
- Office Software 720 2024-04-25 14:52:20
-
- What to do if the upper part of the title text in word is not fully displayed - What to do if the upper part of the title text in word is not fully displayed
- After entering text into the word document, I adjusted the title font size, but found that after the title font size became larger, the upper part of the text was not fully displayed, but the lower part of the text was not affected. Select incomplete text. Right-click and select [Paragraph] from the pop-up menu. In the [Paragraph] dialog box that pops up, click the [Indents and Spacing] tab. In the [Spacing] option, we find that the [Line Spacing] of the paragraph has been set to [Fixed Value] 18 points. And it is because the height of 18 points is not found to meet the display of the title font size. Therefore, we need to make new settings for line spacing. Click the inverted triangle behind [Fixed Value] and select [Single Line Spacing] in the list. Click [OK], so that the title will automatically adjust the line spacing according to the font size, and the text will be
- Office Software 743 2024-04-25 14:49:10
-
- How to set ppt picture style_ppt picture style setting method
- Step 1: Open ppt, click on the picture under the insert option, and then select the picture to be inserted. Step 2: After the insertion is completed, you can set the image style under the format option.
- Office Software 443 2024-04-25 14:43:10
-
- How to clear drop-down list options in Excel_How to clear drop-down list options in Excel
- 1. After opening the excel table, position the mouse to the cleared Excel cell drop-down option. 2. Click - Data - Validity in the menu bar. 3. In the data validation interface, check Apply these changes to all other cells with the same settings. 4. Click - Clear All. 5. At this time, all drop-down options in Excel cells are cleared.
- Office Software 1019 2024-04-25 14:40:45
-
- How to count the number of participants in various regional branches in Excel table_How to count the number of participants in various regional branches in Excel table
- 1. Create a new Excel document, open it and add test data in the table, as shown in the figure. 2. After adding 10,000 test data, enter the calculation formula =SUM((LEFT($D$6:$D$13,2)="Guangdong")*$E$6:$E$13) in cell H5, left is from The string is intercepted from the left, and sum is the sum. The formula means that when the two texts intercepted from the left are equal to the value in the condition, the data is summed. 3. After completing the formula input, press the shortcut key to obtain the calculation result. If you use the enter key here, you will not be able to obtain the calculation result. The details are as follows. 4. Therefore, you need to use the shortcut key shift+ctrl+enter to obtain the result. The result is as shown in the figure. 5. Statistics on the other two provinces
- Office Software 762 2024-04-25 14:40:33