current location：Home > Technical Articles > Topics > excel
- Direction：
- All web3.0 Backend Development Web Front-end Database Operation and Maintenance Development Tools PHP Framework Common Problem Other Tech CMS Tutorial Java System Tutorial Computer Tutorials Hardware Tutorial Mobile Tutorial Software Tutorial Mobile Game Tutorial
- Classify：
-
- How to divide a column by a fixed value in excel?
- Method: First open the excel table, enter the equal sign in column C, then click A1 with the mouse (column A is the data column), then enter the division sign "/", then enter the divisor after the division sign, press the enter key to get the result, and finally Just drag down the mouse to complete the division of all values.
- excel 52190 2020-07-01 14:50:37
-
- How to put the official seal at the bottom in Excel?
- Method: 1. Open the excel table and drag the electronic chapter into the position where the text needs to be covered; 2. Left-click the electronic chapter, click "Graphics Tools" and click "Set Transparent Color"; 3. Click the electronic chapter to change the electronic chapter to After making it transparent, just adjust the position.
- excel 43862 2020-07-01 10:39:38
-
- How to insert a pivot table in excel
- The method to insert a pivot table in Excel is: 1. Set the data source, ensure that the field names are not empty, and the data format remains consistent in the same column; 2. Click the [Insert] option in the upper toolbar, and then click [Pivot Table] ]; 3. Set the data source and placement location of the pivot table.
- excel 14029 2020-07-01 10:04:04
-
- What is the reason why excel runs slowly?
- The reasons are: 1. There may be many small objects in the file that need to be deleted; 2. The slider is very small, and you can reach a very large line number by dragging it downward; 3. The file contains a large number of complex formulas; 4. Use Large pictures are used as work background; 5. Shared workbooks cause an inflated increase in size.
- excel 17544 2020-07-01 09:29:18
-
- How to compare and filter out the same data from two tables?
- Method: 1. Open two excel tables and select a cell range with more data; 2. Click the "Advanced" button in the "Data" tab; 3. Automatically identify the selected cells in the "List Area" of the pop-up window. Cell range, set the "condition range" to the corresponding cell range in another table, and click "OK".
- excel 105249 2020-06-30 17:04:11
-
- How to set excel to display red when greater than 0?
- Method: 1. Open the excel table and select the data that needs to be operated; 2. Click "Conditional Formatting" in the menu bar, and then click "Greater than (G)" in "Highlight Cell Rules"; 3. Select greater than "0 ", "Custom Format" is filled in red, click "OK".
- excel 47599 2020-06-30 13:59:40
-
- How to solve the problem of discontinuous serial numbers on the left side of Excel?
- Solution: 1. Open the excel table and enter continuous serial numbers below the non-consecutive serial number cells in column A; 2. Select column A, click "Data", click "Delete Duplicates", and click "OK"; 3. Select For data in column A, click "Sort" in "Data" and select "Ascending".
- excel 27568 2020-06-30 10:52:54
-
- How to solve the problem that Excel reading mode cannot be found?
- Solution: 1. Open the excel file and click "View" in the menu bar; 2. Click the "Reading Mode" button in the view menu; 3. There is a shortcut button for reading mode in the lower right corner of the table, click this You can also enter reading mode.
- excel 78211 2020-06-30 10:38:29
-
- What is the shortcut key to generate a chart in Excel with one click?
- The shortcut key to create a chart in Excel with one click is F11. There are other shortcut keys in Excel, such as F1 (displays the "Help" task pane); Ctrl+F1 (closes and reopens the current task pane); F5 (displays the "Location" dialog box); F8 (opens or closes extended mode).
- excel 51712 2020-06-30 10:29:46
-
- What should I do if the sub-tables below the Excel table are missing?
- Solution: 1. Open the excel table and click the "File" button; 2. Click "View" in "Options"; 3. Check "Sheet Label" in the pop-up window and click "OK" below.
- excel 61222 2020-06-28 16:04:56
-
- How to sum downward in excel?
- Method for summing downwards in excel: 1. Open the excel table, click "Formulas" in the menu bar, and select "Automatic Sum"; 2. Drag the mouse to select the data that needs to be summed downwards; 3. Click on the keyboard "Enter", click the lower right corner of the cell, when the mouse changes to "+", drag to the right.
- excel 19406 2020-06-28 14:01:19
-
- What is the usage of for loop statement in Excel VBA?
- Usage of for loop statement in VB: 1. [for..next] statement, the judgment structure through i is [for i=initial value to end value step step value]; 2. [for each..next] statement, yes Object variables, the structure is [For each object variable in object collection].
- excel 12125 2020-06-28 11:07:08
-
- How to use the or function in Excel?
- How to use the or function in Excel: 1. The or function is used to test a set of data. As long as one condition is met, the result will return true. The syntax format is [=OR(logical1,logical2,...)]; 2. The or function Generally used in combination with logical functions such as if.
- excel 76499 2020-06-29 09:16:52
-
- How to perform significant difference analysis in Excel?
- Steps: 1. Open excel, click "File", then click "Options" to add the "Data Analysis" module; 2. Click "Data Analysis", click "Unduplicated Two-Factor Analysis", and click "OK"; 3. Select all data including group names in the "Input Area", click on a blank space in the text in the "Output Area", and click "OK".
- excel 93840 2020-06-28 09:39:20
-
- How to extract rows containing keywords in excel?
- Solution: 1. Open the excel table and select the data column cell area; 2. Click "Statistics and Analysis" in "Square Grid" (plug-in); 3. Click "Extract specified area" and check "Contain text" And enter the keywords that need to be extracted; 4. Check "This cell" and click "OK".
- excel 38944 2020-06-28 09:25:35
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
