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 set up automatic reminders for contract expiration in WPS - WPS form tutorial
- 1. Select the area to be reminded. 2. Start>Conditional Formatting>New Rule. 3. Use the formula to determine the cell to be formatted 4. Enter the formula [= first cell in the selected range-today()
- Office Software 323 2024-04-25 12:30:33
-
- How to make a welcome slogan banner in PPT slides_Detailed steps to make a welcome slogan banner in PPT slides
- 1. Create a new PPT document 2. Click the [Design] button on the menu bar. 3. Click the [Page Settings] button. 4. The window shown in the figure will pop up. 5. Select [Banner] in the slide size. 6. Enter content in the banner. 7. The effect is as shown in the figure.
- Office Software 1143 2024-04-25 12:28:05
-
- How to insert 2 slashes in Excel table_How to insert 2 slashes in Excel table
- 1. Adjust the cells where you want to draw a diagonal header, and use [Straight Line] on the [Drawing] toolbar to draw a diagonal line. (Note that the endpoint of the straight line should be in contact with the edge of the cell, so that when the cell is adjusted in the future, the straight line will change accordingly) (Insert---Shape--Line). 2. Use [Text Box] to enter text, set the text box border to [No Line Color], and the text box [No Fill Color]. It is best to enter one field in one text box, so that typesetting is easier.
- Office Software 982 2024-04-25 12:22:05
-
- How to make word art with paint effect in ppt_Tutorial of making word art with paint effect in ppt
- 1. First select the text box. 2. Click Object Properties. 3. Click on the picture or texture to fill. 4. Click on the local file. 5. Select the paint picture. 6. The final rendering is as shown in the figure.
- Office Software 913 2024-04-25 12:20:39
-
- How to set up automatic updates in WPS2019_How to set up automatic updates in WPS2019
- First we open WPS2019 and click New. Next, in the new tab page that pops up, select the text function on the blue background bar, and then select New Blank Document. In the newly created text document, we manually enter a date. The purpose of manually entering the date here is just for comparison. Next, click the Insert function on the WPS2019 menu bar. Then click on the date function in the upper right corner. In the date and time interface that pops up, you can select the format you need to use from the list on the left. After selecting, remember to check the box in front of Automatically update on the right, and then click OK. Next, you can turn off WPS201 and then turn it on again. You will see that the manual input above will not change, and the commands below will change with the update.
- Office Software 318 2024-04-25 12:20:32
-
- How to add operators to word 2010 formulas
- Open the word2010 document window, click the formula to which the operator needs to be added 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 [Operator] option in the open drop-down menu, and select the required operator in the open operator panel.
- Office Software 677 2024-04-25 12:20:24
-
- Instructions for using Excel subtraction function
- First, enter the formula [=A1-B1] (without quotation marks) in the [C1] cell, then press Enter (i.e. press the [Enter] key on the keyboard) to select the [C1] cell, and move the mouse to the [C1] cell In the lower right corner, a small black cross will appear. At this time, press the left button of the mouse and drag it to cell [C11]. Then you will find: the difference between the data in column A minus the data in column B in each row is listed in column C of the same row. In addition, Excel It can also be used as a calculator. When we want to calculate [3.1113-1.765], we can enter the formula [=3.1113-1.765] in the [A1] cell, and then press Enter (i.e. press the [Enter] key on the keyboard) then the [A1] cell [3.111] is displayed in the grid
- Office Software 431 2024-04-25 12:20:11
-
- How to design money bag pattern in wps
- After creating a new presentation, click Insert and then click Shape. Select the recommended money bag shape, hold down the left mouse button and draw a money bag on the document. Change the default color to yellow. Delete redundant text boxes. At this time, only the money bag was left on the manuscript, and the drawing work was completed. Click the cross in the upper right corner to save it and follow the save process.
- Office Software 597 2024-04-25 12:13:39
-
- How to use simple markup in Word2019
- 1. Set the mark type to [Simple mark]. Open the original file? Switch to the [Review] tab,? Click the lower triangle button to the right of [All Marks] in the [Revisions] group,? Click the [Simple Markup] option in the expanded drop-down list, as shown in the figure. In Word 2019, use the revision mode of [Simple Markup] to view the document after simple markup. At this point, you can see the simply marked document, with a red revision line displayed on the left edge, as shown in the figure.
- Office Software 501 2024-04-25 12:10:42
-
- How to quickly set the same format for multiple data in Excel
- First open the Excel table that needs to be edited. Select the "Start" menu in the menu bar. Click on the "Start" menu and select "Find and Replace" in the tab. Click "Replace" to open the Find and Replace dialog box. Click "Options" to open the replacement options, click "Format", select the format in the cell, select any cell to change the format, and set the format in "Replace With". Click OK to complete the replacement.
- Office Software 697 2024-04-25 12:10:06
-
- How to quickly merge cells and add serial numbers in Excel_How to quickly merge cells and add serial numbers in Excel
- First open the corresponding Excel table: right-click column A above the table and select [Insert] in the pop-up menu: In this way we insert a new column: select the cell in column B, move the mouse to the lower right corner, and wait until the cursor turns black Cross shape, drag the mouse to complete the filling: select the cells in column A, hold down the [Delete] key on the keyboard to delete excess text, enter [Sequence] in cell A1: select the remaining cells, hold down the [CTRL] key Click cell A2: Enter [=COUNT($A$2:A2)+1] in the cell: Press and hold the [CTRL] + [Enter] keys to complete the final filling:
- Office Software 830 2024-04-25 12:10:06
-
- How to edit text using word copy method_How to edit text using word copy method
- 1. Open a file at will. This file is irrelevant, just a tool. 2. Click File in the menu bar of Word, and then select Open. 3. Then find your important document and create a copy of it. 4. Right-click on the important document and select New. 5. A prompt box pops up, click OK. 6. Return to the open window, pay attention here, click Cancel instead of click Open. 7. At this time, a copy file is opened, and the modifications made here will not affect the original file. Just delete something. 8. Then go back to the original file to see if there are any changes. The deleted things are still there. This means that the file just opened is a copy file.
- Office Software 514 2024-04-25 12:07:19
-
- How to calculate the postage of each express delivery in Excel table_How to quickly calculate the postage of each express delivery in Excel table
- 1. First look at the effect. 2. Create a new auxiliary column called regional cost. Use VLOOKUP to reference all regional costs. The formula is as shown in the figure. 3. Pull down the data so that you can get all the regional cost data. 4. Next, you can calculate the postage. The IF function is used here. The formula is as shown in the figure. The meaning of the formula is that if it is greater than 1, it will return 5 yuan + regional fee. If it is greater than 1, it will return 5 yuan + a multiplier other than 1. To 3+ area fee. 5. Scroll down again to get the full postage. 6. You can also modify the formula here and embed VLOOKUP into IF, which means replacing the auxiliary column with VLOOKUP. The formula is as shown in the figure. Note: For VLOOKUP function references, remember to press the area you want to reference.
- Office Software 705 2024-04-25 12:07:09
-
- Where to set the position and level of ppt word art_How to set the position and level of ppt word art
- Step 1: Open ppt, click [Insert], click [WordArt], select the text type to insert. Step 2: Click the word art border, right-click the mouse, click [Size and Position] and set the horizontal position.
- Office Software 685 2024-04-25 12:04:28
-
- How to merge shapes to make a turn bar in PPT_The specific steps of merging shapes
- 1. Use [Rounded Rectangle] to draw a rectangle. 2. Copy and paste one, and move the copied rectangle to the upper left to the appropriate position. 3. Select all rectangles and click [Format] of the drawing tool. 4. Click [Cut] in [Merge Shapes]. 5. Get a turn bar.
- Office Software 821 2024-04-25 12:01:33
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
