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 automatically update the serial number of a row in Excel?
- How to add a row of serial numbers in Excel to automatically update: first open a sample workbook; then click on the cell "A3" where the serial number 1 is located, and enter "=row()-2"; finally fill in the formula.
- excel 22022 2020-07-07 13:30:40
-
- How to batch merge work pages in excel?
- How to batch merge work pages in Excel: First create a new worksheet on the front page; then [right-click] on the newly created sheet and find [View Code]; finally copy the code into it and click [Run] under [Run]. Run subprocess/userform].
- excel 8814 2020-07-07 11:31:02
-
- How to replace a certain part of the content in excel formula?
- How to replace a certain part of the content with an excel formula: first open the table, enter the function [=SUBSTITUTE(A1,"Business","Business Center",1)] in the corresponding cell; then confirm and pull down to copy the function; finally save the file. .
- excel 26191 2020-07-07 11:11:40
-
- How to program excel spreadsheet?
- How to program excel spreadsheet: first open the software and click the [File-Options] option; then click the custom ribbon, check the development tools, and click OK; finally, select insert [Module] in the VBA window, create a new module, and edit on the right Just enter the code into the box.
- excel 48270 2020-07-07 10:50:29
-
- What should I do if the shortcut key for cropping pictures in Excel does not work?
- Solution to the invalid shortcut key for cropping pictures in Excel: 1. Open the data and use a shortcut key command to insert a row [ctrl+shift+"="]; 2. Click the mouse on the main column of the row and column and then use it; 3. You can Find the corresponding key on the full keyboard.
- excel 8289 2020-07-07 10:40:43
-
- How to add unit multiplication formula in Excel table?
- How to use unit multiplication formula in excel table: first open the table and enter the corresponding data; then enter the formula in cell C1 [=LEFT(A1,FIND("jin",A1)-1)*LEFT(B1,FIND(" Yuan",B1)-1)]; if the final unit is inconsistent, you can modify it.
- excel 34205 2020-07-07 10:31:30
-
- How many worksheets can you create in Excel?
- Excel can create up to 255 worksheets. How to check the number of worksheets: first open excel, click "File" in the menu bar; then click "General" in "Options"; then click "Number of worksheets included" and enter a value. When the value exceeds 255 , a reminder will pop up: "Enter an integer from 1 to 255."
- excel 40107 2020-07-07 10:09:34
-
- What is the difference between excel suffix .xls and .xlsx?
- The difference is: 1. The corresponding versions are different. The ".xls" file corresponds to "Office EXCEL 2003" and previous versions, and the ".xlsx" file corresponds to 2007 and later versions; 2. ".xlsx" files compare " .xls" file takes up less space and the calculation speed will be faster.
- excel 26809 2020-07-06 16:48:08
-
- What is the usage of dcounta function in excel?
- The dcounta function is used to return the number of non-empty cells in a column in a list that meet specified conditions. The syntax is "DCOUNTA(database, field, criteria)"; the parameters in turn represent the cell range that constitutes the list, the column used by the specified function, and the cell range that contains the specified criteria.
- excel 10890 2020-07-06 14:08:03
-
- After generating an excel chart, what should the user do if they want to modify the chart?
- Solution for users who want to modify the chart after generating an excel chart: First, select the legend in the shortcut menu and click the format button to the right of the drop-down arrow; then click the Position tab in the legend format tab and select Place on Card Options under; finally you can change the legend position and size.
- excel 11500 2020-07-06 11:44:09
-
- How to freeze a row in a table
- Method to freeze a row of the table: 1. Click "View" → "Freeze Panes" → "Freeze Split Panes" in the menu bar; 2. Click "View" in the menu bar and select "Freeze Panes" → "Unfreeze panes".
- excel 21548 2020-07-04 11:53:28
-
- How to freeze the selected row in excel
- The method to freeze the selected row in Excel is: first open the Excel table, select the row next to the row to be frozen; then click [View], and click [Freeze Panes]; in the last pop-up option, click [Freeze Panes] again 】That’s it.
- excel 13509 2020-07-03 16:20:34
-
- What should I do if Excel filtering and sorting are grayed out?
- The solution for Excel filtering and sorting is gray: first left-click and drag to select the document data, and select copy; then create a new menu on the desktop and select exccel; finally, paste the copied content into it.
- excel 46889 2020-07-03 15:41:38
-
- How to randomly group seats using excel roster?
- How to randomly group seats in the excel roster: first fill in all the seats in order, add a column next to the "seat" column, enter "=rand()"; then double-click the lower right corner [+]; then select "seats" " and "auxiliary column", click "Sort"; finally set the keyword to "auxiliary column" and click "OK".
- excel 10052 2020-07-03 10:25:13
-
- What operators can be used to concatenate strings in excel?
- You can use the "&" operator in excel to concatenate strings. There are other operators in excel, such as: arithmetic operators (+, –, *, /, %, ^); comparison operators (=, >, <, >=, <=, <>); reference operators symbol(:,,).
- excel 19332 2020-07-03 09:53:58
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
