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 refer to cell formulas
- The method of cell formula reference: first open the Excel table file; then directly click the reference cell to generate the reference cell address; then click the corresponding cell, such as "=A1+B1"; finally click the "+" sign on the keyboard And click the "B1" cell to generate the calculation formula.
- excel 10646 2020-04-30 10:50:31
-
- How to arrange table contents in ascending column order
- How to arrange table contents in ascending order of columns: first open the excel table that needs to be sorted; then find and open the "Data" option in the menu bar; then click "Data" and select the "Sort" option in the pop-up drop-down box; finally Just click "Ascending" in the pop-up "Sort" window.
- excel 14288 2020-04-30 10:36:11
-
- What should I do if the subtotals in Excel are gray?
- The method to solve the problem that the classification summary is gray in Excel is: 1. First open Excel and switch to the [Design] column; 2. Then find the [Convert to Area] option in the pop-up property bar and click this option. .
- excel 12488 2020-04-30 09:39:32
-
- What should I do if blank underlines are not displayed in Excel?
- The solution to the problem that blank underlines are not displayed in Excel is: 1. First, select the cell, right-click, and select the [Format Cells] option; 2. Then switch to the [Number] column and select the [Custom] option; 3. Finally Just enter [@*_] in the type input box.
- excel 37545 2020-04-28 10:19:47
-
- How to hide multiple rows in excel
- The method to hide multiple rows in Excel is: 1. First open the Excel table and select the rows that need to be hidden; 2. Then click the [Format] and [Row] options in sequence; 3. Finally, select [Hide] in the pop-up menu.
- excel 7923 2020-05-06 17:00:32
-
- What is the use of mod function in excel?
- The mod function in excel is a remainder function, its format is: mod(nExp1,nExp2), which is the remainder after dividing two numerical expressions. The sign of the result is the same as the divisor.
- excel 9694 2020-05-12 17:07:22
-
- How to modify row height and column width in excel
- How to modify the row height and column width in Excel: 1. First open the Excel table and select the cells that need to be modified; 2. Then open the format settings, click [Row Height] to modify the row height value, and then click [Column Width] to modify The column width value is sufficient.
- excel 5917 2020-05-06 16:47:12
-
- What is the use of excel
- The functions of excel: 1. It can perform complex data calculation, processing and analysis; 2. It can establish data models for practical problems; 3. It can reduce the human workload and engage in complicated data processing work content in the management process; 4. Excel The VBA function can extend the functions of Excel to realize office automation.
- excel 7091 2020-05-13 13:20:38
-
- What to do if excel freezes
- Excel is stuck because too many formulas have been inserted. The solution: first open the Excel worksheet and select "Start" - "Conditional Formatting" in the toolbar; then select "Clear Rules" - "Clear Entire" in the drop-down box Worksheet Rules"; finally clear all formulas and formats in the table.
- excel 23804 2020-05-12 13:38:21
-
- What is an Excel workbook that calculates and stores data?
- An Excel workbook is a file that calculates and stores data. The so-called workbook refers to a file used to store and process work data in the Excel environment. In other words, an Excel document is a workbook, which is one or more worksheets in the Excel workspace. A collection with the extension "XLS".
- excel 20197 2020-05-10 14:28:36
-
- What are the hidden shortcut keys in excel?
- In Excel, the shortcut key [Ctrl+9] is used to hide the row where the cell or range is located; the shortcut key [Ctrl+0] is used to hide the column where the cell or range is located; and the shortcut key [Ctrl+Shift+9] 】 is used to unhide rows of cells or ranges.
- excel 34338 2020-05-10 14:28:20
-
- How to display numbers in Excel in ID card
- How to display numbers on your ID card in Excel: First open the Excel table; then right-click on the number cell and select Format Cell; then in the pop-up "Format Cell" window, select the option "Number, Text"; and finally re- Enter the ID number and all the ID numbers will be displayed.
- excel 5333 2020-05-10 14:26:13
-
- How to fill in the sheet form on mobile phone
- How to fill in the sheet form on the mobile phone: first open the mobile phone and find the "wps office" icon on the desktop; then click the [+] button, select the type of file to create and create a new form; then click the New Blank option; finally on the form page, Click on a cell to enter content.
- excel 18015 2020-05-10 14:25:49
-
- How to make documents editable online
- How to set up document online editing: 1. Log in to the Kingsoft Document web page. 2. Select the document that requires collaboration between multiple people and click "Share". 3. When sharing, select "Editable" as the permission, and then send the obtained link to your friend. The friend can open the link and log in to the account to edit.
- excel 78843 2020-05-10 17:10:30
-
- How a table refers to table data in another file
- Method for a table to reference data from another table: Open the Excel table file, select "Object" in the "Insert" tab, then enter the "Create from File" tab in the pop-up interface, click Browse, and select the table to reference data. Just file.
- excel 15456 2020-05-10 17:09:48
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
