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 change the default currency format in Excel_How to change the default currency format in Excel
- 1. Click the [Start] menu on the desktop, and click the [Settings]-[Control Panel] command in the list. 2. Open the [Regional and Language Options] dialog box and click the [Customize] button in the [Regional Options] tab. 3. Open the [Customize Regional Options] dialog box, click the [Currency] tab, and select the currency you want to change in the currency symbol list. The number of decimal places can also be set according to your needs. 4. At this time, return to Excel and set the cell to currency format. At this time, it will become the default currency format you set.
- Office Software 1176 2024-04-25 11:04:05
-
- How to operate irregular filling in Excel
- First we prepare a form. To fill in all the departments, the normal operation is to drag and fill in one by one, but that doesn't work. Here are some tips. First select the column to be filled, CTRL+G to open the positioning settings, and select null value in the set condition. Then enter equals and click on the cell above. Finally, CTLR+Enter, all cells will be filled. Isn't it very simple? The same operation can also be applied to other irregular tables, but the input content will be rewritten according to your filling requirements, so CLTR + Enter is the soul of irregular filling.
- Office Software 1086 2024-04-25 11:01:37
-
- How to make calligraphy posts in word2010
- ①Click File--New--Calligraphy Copybook to create a calligraphy copybook document. ②Select Chinese characters and add them. ③Preliminary completion, as shown in the picture. ④Click the calligraphy label to select rice grid, field grid or others in the grid style. ⑤ Cancel the hollow words in the options, and the solid words can be displayed. ⑥You can see the final rendering below.
- Office Software 1115 2024-04-25 11:01:29
-
- How to calculate the day of the week for a certain date in Excel_How to quickly calculate the day of the week for a certain date in Excel
- First open a table with dates: select cell B2, click the [Formula] option on the toolbar, and select [Insert Function] in the drop-down menu: In the pop-up Insert Function dialog box, select [Date and Practice], Select [WEEKDAY] in the function column and click OK: In the pop-up function parameter dialog box, enter [A2] in the first column and [2] in the second column, click OK: Finally, we complete the filling and all cells will be found. The day of the week appears in the grid:
- Office Software 687 2024-04-25 11:01:15
-
- Tutorial on how to deal with word changes when opening PPT on other computers
- First enter the PPT options, enter the [Save] column, check [Embed fonts in the file], and then confirm to save. In this way, after you save the PPT file next time, all the fonts in it will be saved, and they can be displayed normally on other computers, and others can also see your high-quality PPT.
- Office Software 1102 2024-04-25 10:58:40
-
- How to quickly count total sales in excel_Introduction to the method of quickly counting total sales in excel
- 1. There is now a sales table that contains sales data for multiple years, and the order is disordered. Now we are asked to quickly calculate the total sales volume this year. 2. Here we use the SUMPRODUCT function for statistics, enter =SUMPRODUCT() in the cell. 3. We first need to count this year’s information, and enter the parameters here (YEAR(A2:A15)=YEAR(TODAY())). 4. Then multiply the calculated data by the sales array, and the function becomes =SUMPRODUCT((YEAR(A2:A15)=YEAR(TODAY()))*B2:B15). 5. After completing the function, the total sales volume of this year will be automatically displayed. Through this method
- Office Software 1031 2024-04-25 10:58:05
-
- How to use the click-to-enter function for word documents in wps - the steps for the click-to-type function for word documents in wps
- 1. If you want to enter text elsewhere in the document and pressing Enter is too troublesome, you can use the [Click to Enter] function. For example, if you want to enter content in the blank space, 2. Double-click the mouse in the blank space to enter text. You can see the cursor flashing. 3. Double-click the classmate who cannot be edited, click File - Options, find [Edit], and check [Click to Enter].
- Office Software 996 2024-04-25 10:55:39
-
- Tutorial on how to compare two columns of data in Excel and find differences
- First, let’s take the following two columns of data as an example. First, we frame-select the original data on the left, making sure that the table header is also frame-selected. Then we select [Data] - [Advanced Filtering] above, and select the check area on the right in the condition area. In this way, there is no problem with the data still in our table. The table will automatically filter it, and then we fill all cells on the left with a color. Finally, clear the advanced filtering so that data without color filling in the table is problematic data, allowing you to see it at a glance.
- Office Software 1080 2024-04-25 10:55:18
-
- Steps to enable or disable smart paragraph selection function in word 2010
- Step 1. Open the word2010 document window and click the [File] → [Options] command. Step 2. Open the [Word Options] dialog box and switch to the [Advanced] tab. Select or clear the [Intelligent Paragraph Selection] checkbox in the [Editing Options] area, and click [OK].
- Office Software 579 2024-04-25 10:50:43
-
- Detailed method to set and display hidden text in word2010 document
- 1. Set hidden text You can set specific text content as hidden text in the Word2010 [Font] dialog box. The specific operations are as follows: Step 1: Open the Word2010 document window and select the text content that needs to be set as hidden text. Click the [Show 'Font' dialog box] button in the [Font] group of the [Start] ribbon. Step 2. Open the [Font] dialog box, select the [Hide] checkbox in the [Effect] area, and click the [OK] button to hide the text. 2. Display the hidden text that is set as hidden text in the word2010 document. It is not displayed by default. If you need to display the hidden text of the current word document, you can do it as follows: Step 1, open the word2010 document window, follow the steps
- Office Software 1262 2024-04-25 10:50:12
-
- How to insert animation in word-detailed steps to insert Flash animation in word
- Open the word document where you want to insert Flash animation, place the cursor at the required position, find the [Insert] tab on the menu bar, click on it, find [Object] in the [Text] option group on the menu bar, click on [Object] in the dialog box, and click Click the [Create from File] tab, click the [Browse] button after [File Name], find the file according to the path of the animation, and select it. After clicking [Insert] to copy the path under [File Name] in the [Object] dialog box, After clicking [OK] to return to the document editing page, use the right button of the mouse to select the inserted object, select [Properties] in the right-click menu, click to find [Movie] in the [Properties] dialog box, and paste the path just copied in the blank space at the back. After completing the input, click [×] to close the [Properties] dialog box and find the menu bar [Develop
- Office Software 802 2024-04-25 10:49:06
-
- How to calculate percentage in Excel
- 1. Open the Excel table that needs to be set. 2. To sum first, select the cells to be summed and a blank cell, and click [Automatic Sum]. 3. In addition to quick automatic summation, you can also use formulas to perform summation. Click on the cell to fill in the summation result, enter =sum(b3:b6) and click Enter. The range in brackets is the selected summation range. 4. Before calculating the percentage, set the cell format first, select the cell for which the percentage needs to be calculated, and click [Set Cell Format]. 5. Select [Percent] to set the number of decimal places. Set [0] here. 6. Click on the cell and enter the formula [=b3/b7], which means [percentage = number of people/total number of people].
- Office Software 1307 2024-04-25 10:46:35
-
- How to solve the privacy issue warning in Excel_How to deal with the privacy issue warning in Excel
- 1. Open the form that often pops up the privacy warning dialog box. After opening, you can see a small inverted triangle in the upper left corner of the form. Click on the triangle. 2. After clicking, many options will drop down for us to choose from. At this time, click the [Other Commands] button. 3. Then a dialog box will pop up, click the [Trust Center] option on the left side of the dialog box. 4. After selecting the Trust Center button, enter the Trust Center control panel. At this time, there will be a [Trust Center Settings] option in the lower right corner of the panel. Select this option. 5. Then you will enter [Personal Information Options]. At this time, you will see an option [Delete personal information from file properties when saving]. Remove the √ in the box in front of this option. 6. After √ is removed, it will be displayed as shown in the figure. At this time, the selection dialog box
- Office Software 793 2024-04-25 10:46:26
-
- A simple way to cancel spaces and turn them into boxes in word
- There are various marks in word, including paragraph marks, space marks and other symbols. Therefore, these markers sometimes display different markers depending on the environment in which they are set. Under normal circumstances, the space marks in Word are hidden and not displayed. But if your word spaces become boxes or dots, how do you cancel these boxes and restore them to their original state? as the picture shows.
- Office Software 978 2024-04-25 10:46:19
-
- The operation process of setting up traditional pop-up menu in wps2019
- After opening the document editing page of wps2019, click the drop-down arrow next to the first menu [File]. You can now see and use traditional pop-up menus. However, we must remind everyone that the parent menu items of the wps2019 traditional menu are not exactly the same as the parent menu items of the new version of the tabbed menu. As you can see from the diagram below, not only the names are different, but the number of items is also different. In addition, even if the menu item of the wps2019 traditional menu has the same name as the tab menu item, the submenus under it are different. For example, [Insert] item. However, although the parent menus and submenus of traditional menus and tab menus are different, when it comes to specific functions, the final interface displayed is exactly the same. For example, the following diagram
- Office Software 885 2024-04-25 10:46:11
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
