current location：Home > Technical Articles > Topics > excel
- 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 use excel nested functions
- How to use excel nested functions: First open an excel worksheet, select cell D3, click the "Insert Function" button in the "Function Library" group under the "Formulas" tab; then click the "Insert Function" that pops up Select the SUM function in the dialog box; finally set the Number1 and Number3 parameters and confirm.
- excel 16505 2020-03-13 09:33:37
-
- Where to find excel installation package
- How to find the excel installation package: first click [Start] in the lower left corner of the computer; then find [office] in the application list; then right-click on office and select [Properties]; finally, you can view it in the [General] tab to the excel installation package.
- excel 20957 2020-03-13 09:28:11
-
- What should I do if excel sharing is found to be unreadable and only read-only?
- The solution to the problem that excel sharing is found to be unreadable and read-only: first open office excel and open the problematic excel file; then when opening, select open and repair; then after the pop-up box, select repair excel file; finally wait for repair That's it.
- excel 6061 2020-03-13 09:22:54
-
- How to use trigonometric functions in excel
- How to use trigonometric functions in Excel: First open Excel, find "Formulas", click "Mathematics and Trigonometric Functions"; then click "Mathematics and Trigonometric Functions", find [Sine] and click; then enter the value in the pop-up dialog box; Finally click [OK].
- excel 12983 2020-03-13 09:16:43
-
- How to highlight data greater than 100 and less than 200 in excel
- How to highlight data greater than 100 and less than 200 in Excel: first create a new table and fill in some data; then select the data, click Conditional Formatting - Highlight Cell Rules - Between; then fill in 100 and 200 and click OK; finally you can see Effect.
- excel 29270 2020-03-12 11:57:46
-
- How to add the same numbers to one column in Excel
- How to add the same numbers to a column in Excel: first create a new table and fill in some data in a column; then select the column data, right-click to set the cell format; finally select Custom and enter the number you want to add in the type.
- excel 43636 2020-03-12 11:32:25
-
- How to use index function in excel
- The index function in Excel can flexibly refer to cells or elements in an array. It refers to a cell range or elements in an array through row numbers and column numbers. The syntax is INDEX(array, row_num, [colomn_num]).
- excel 8832 2020-03-12 10:58:38
-
- How to set multiple selections in Excel drop-down box
- How to set multiple selections in excel drop-down box: first open the excel table; then display the "Development Tools" tab; then set the option content of the drop-down list; finally insert the ListBox list box control and insert the code "Private Sub ListBox1_Change()" Just save it.
- excel 47803 2020-03-12 08:59:34
-
- How to make drop-down box in excel
- How to implement the excel drop-down box: first select cell E2, open [Data Validation] in the [Data] menu; then select "Sequence" in the allow drop-down menu; then enter "Male, Female" in the source box with English status Separate by the "," sign below; finally confirm to return to the data table and click to select from the drop-down box.
- excel 15885 2020-03-11 09:07:00
-
- How to highlight duplicate values in excel
- How to mark duplicate values in red in Excel: Select the entire table, and then select "Start" - "Conditional Formatting" - "Highlight Cell Rules" in the upper toolbar. Next, select "Duplicate Value", set the value to red in the pop-up box, and click OK.
- excel 53245 2020-03-11 08:57:39
-
- How to solve the problem that the excel table does not display the sheet tag?
- Solution to the excel table not displaying the sheet tag: 1. Click "File" in the upper left corner of the interface, and then enter "Options". 2. Go to "Advanced" on the left in the options interface, find "Display options for this workbook" on the right, and check "Show worksheet labels" below.
- excel 37151 2020-03-11 08:40:19
-
- How to use mail merge function in excel
- The method to use the mail merge function in Excel is: 1. First, switch to the [Mail] tab; 2. Then, click [Select Recipients], [Use Existing List], [Insert Merge Field], and [Finish and Merge]. Merge] option.
- excel 22299 2020-03-10 17:48:11
-
- How to convert pdf in excel without pagination
- How to convert PDF without pagination in Excel: 1. First, switch to the [Page Layout] tab and click the [Print Area] option; 2. Then, click [File] and select the [Print Preview] option; 3. Finally, click [ Page Setup] and select the [Print worksheets together] option.
- excel 20100 2020-03-10 17:31:07
-
- After entering the bank card number in the excel form, the number changes.
- The method to solve the problem that the numbers change after entering the bank card number in the Excel table is: 1. First, open the Excel table and select the cell where the data is located; 2. Then, right-click the cell and select [Format Cell]; 3. Finally, change the cell format to text.
- excel 16963 2020-03-10 17:19:50
-
- Convert excel table to pdf with incomplete content
- The solution to the incomplete content of the Excel table converted to PDF is: 1. First, click the [View] option in the menu bar; 2. Then, click [Page Preview] and drag the blue line in the page preview to the edge of the table until Cover the entire table; 3. Finally, output it as a PDF file.
- excel 7611 2020-03-10 17:10:51
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
