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 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 1150 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 927 2024-04-25 14:40:33
-
- How to set thousands separator for numerical values in Excel
- 1. Open 2016e2. Select the data in the table that needs to set the thousands separator. 3. Press Ctrl+1 and click on the value. 4. Find the thousands separator. 5. Then check the check box in front of the thousands separator. 6 .Click OK 7.The thousands separator is set
- Office Software 706 2024-04-25 14:40:23
-
- How to make a salary slip with double row header in wps form - wps form tutorial
- 1. Copy the header and paste it below the table. 2. Enter 1 under the job number column. 3. In the cell under the name column, enter the formula and insert formula > vlookup. Data table: After selecting all tables, press F4 to quickly convert to absolute references. 4. Copy the formula and paste it in other cells such as bonus and overtime. 5. Select the table you just created and add a border. 6. Pull down the salary slip and it’s ready. To make it easier to print and cut out, you can select a blank line and pull it down.
- Office Software 1047 2024-04-25 14:37:15
-
- How to check name and job number in Excel
- First, select the original data on the left and click [Advanced] in [Data]-[Filter]. In the condition area, select the table to be checked on the right. After clicking OK, the data will be filtered out, and then fill the original data table on the left with a color. Finally, click [Clear] in [Data]-[Filter], and all data will be restored. Then the data without color in the table on the left is erroneous data, so check it carefully.
- Office Software 939 2024-04-25 14:34:26
-
- Detailed operation process of using formulas to calculate taxes in WPS Office2012
- First, make an ET table as shown below: Select cell C2, click the [Insert Function] button in the Formula tab, open the Insert Function dialog box, and click [Calculate Personal Income Tax (before 2011-09-01)]. In [Pre-tax Salary Income], enter August’s salary in all cells [C2] (enter the value to calculate the result directly, here for obvious comparison, the reference cell data is used), click the Insert Formula button, and the calculation will be done It’s time to adjust the personal income tax that should be paid. Isn’t it very simple? In the same way, calculate the personal income tax payable after September 1, 2011 in D2. Enter the formula [=C2-D2] in cell E2 to quickly calculate how much less you have to pay.
- Office Software 1215 2024-04-25 14:34:19
-
- How to extract zodiac sign based on birthday in Excel
- First of all, you need to remember the following formula, which is the functional formula for zodiac conversion. =MID("Rat, Cow, Tiger, Rabbit, Dragon, Snake, Horse, Sheep, Monkey, Chicken, Dog, Pig", MOD(YEAR(A1)-4,12)+1,1) Please note that A1 here is not a fixed cell, that is to say, your Fill in the box where the birthday date is in the form. Let's take the table below as an example. We enter the formula in the zodiac table and change A1 to B2. Finally, press Enter and the zodiac sign will be displayed. Finally, we can hold down CTRL to fill in the form.
- Office Software 608 2024-04-25 14:34:11
-
- Detailed steps for spelling and grammar checking in word 2016
- Start word2016 and click the File tab of the menu, as shown in the figure. Click the options button as shown in the figure. Click the Proofing tab, set the spelling check items, and click OK, as shown in the figure. Enter the content, click Review, and click Spelling and Grammar Check, as shown in the figure. The spell check item will appear on the right side. Here we can make a selection based on the results of functional association and select playing, as shown in the figure. Double-click playing, the document will replace the incorrect spelling, and the results of the spell check will pop up, as shown in the figure. Click OK to end the spell check, as shown in the figure.
- Office Software 681 2024-04-25 14:28:17
-
- How to create map charts in Excel
- 1. Download and install [officemap] [This content describes the need to install a plug-in before installing the program. The plug-in is used to support the normal operation of the program. 3. After the plug-in is installed, first run the Microsoft Office Excel 2007 program directly, and then click [Office Button] -> [Excel Options]. 4. In the [Excel Options] window that opens, switch to the [Trust Center] tab and click the [Trust Center Settings] button. 5. In the window that opens subsequently, switch to the [Macro Settings] tab, check [Trust access to the VBA Project Object Model], and click [OK] to complete the settings. 6. Next, run the shortcut on the desktop [OfficeMa
- Office Software 1280 2024-04-25 14:10:42
-
- Excel column chart visualization operation method
- First, let’s demonstrate the incorrect method of inserting a histogram. Just like the table below, directly select the table and then generate the histogram. The boss will definitely not understand such a picture and ask you to redo it. At this time, we only need to classify the data. Taking the table above as an example, here we separate the data from different years, such as staggering their data. Finally, use the histogram again, and then look at the data. Is it very intuitive? The histogram inside will be marked and displayed in different colors, which looks very comfortable.
- Office Software 551 2024-04-25 14:10:34
-
- Detailed tutorial on implementing interlaced color changing in Excel
- 1. Use the Apply Table Format function. Excel 2010 has a [Apply Table Format] function that can change the color of alternate rows. It is very convenient to operate. Just select the area that needs to be formatted and select the style in [Start->Format Table] to achieve it. as the picture shows. 2. Use the functions of conditional formatting and functions. This method can be perfectly implemented in Excel2003 or a later version of Excel2010. First, select the area where you want to change the style. Operation under Execl2010: Start->Conditional Formatting->Highlight Cell Rules->Equal to (E)...->Enter [=MOD(ROW(),2)=0] in the input box, and you can Realize interlacing
- Office Software 555 2024-04-25 14:10:17
-
- Introduction to the process of adjusting text line spacing in Excel tables
- 1. Open Excel and create a new table. 2. Enter the content that needs to be adjusted, and you can use the shortcut key [Alt+Enter] to perform a line break operation. 3. Right-click the cell and select [Format Cells]. 4. In the settings window, click [Alignment] settings. 5. In the [Vertical Alignment] option, select [Distributed Alignment], and then click the [OK] button to complete the settings. 6. The effect is as shown in the picture, and the line spacing between text has been adjusted.
- Office Software 1329 2024-04-25 14:07:07
-
- How to read Pdf documents in WPS2019_How to read Pdf documents in WPS2019
- First we find the PDF document we want to open on the computer. Right-click the PDF document, and then click the [Open with/wpsOffice] menu item in the pop-up menu. At this time, our PDF document will be automatically opened using wps2019. In order to facilitate reading PDF documents, we can also make corresponding settings for WpsOffice and click the [Settings] button in the upper right corner. Next, the WpsOffice configuration window will open. In the window, we can set the page zoom, page arrangement, etc. At the same time, in the opened general settings window, set the page background color to eye protection mode. At this time we can see the effect of wps2019 opening PDF documents.
- Office Software 1086 2024-04-25 14:04:05
-
- How to open two Excel windows at the same time
- 1. Double-click to open the first Excel table (network experience). 2. Do not double-click the excel you want to open (this is very important). Right-click the excel application icon and select excel2007. At this time, drag the network excel into the new window that pops up, so that we can open two excel windows at the same time like word. Repeat the above operations to open multiple excel window applications. Just use [alt+TAb] to switch between multiple worksheets.
- Office Software 768 2024-04-25 14:01:21
-
- The operation process of setting the soft edge effect of word art in word2010 document
- Open the word2010 document window, click the WordArt object that needs to be set with a soft edge effect, and put it in the editing state. In the [Drawing Tools/Format] ribbon, click the [Shape Effect] button in the [Shape Style] group. Open the shape effects menu and point to the [Soften Edges] option. If you select any soft edge effect in the soft edge effect list that is opened, the word art in the word2010 document will display the final effect in real time. After confirming to use a certain soft edge effect, click on it. If you want to further set the soft edge effect, you can select the [Soft Edge Options] command in the soft edge effect list. Open the [Set Picture Format] dialog box. In the [Glow and Soften Edges] tab, the user can further set
- Office Software 617 2024-04-25 13:58:32
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
