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 set ascending order in excel
- How to set ascending sorting in excel: first select the value, and click the [Data-Sort] option in sequence; then select the [Options] button, and in the [Sort Options] dialog box that pops up, check the [Sort by Row] option; Finally, select the value in [Sort by], select ascending order in [Order], and confirm.
- excel 31074 2020-08-01 11:32:13
-
- How to make the table adjust automatically?
- How to make the table automatically adjust: first open the "Excel" table; then click the "Format" button in the "Cell" option group; then select the "Automatically adjust column width" option in the drop-down menu; finally click on the "Alignment" option Select "Automatically wrap text" in the card and click "OK".
- excel 10699 2020-07-31 11:58:22
-
- How to change a negative number in Excel with one click?
- How to change a negative number in Excel with one click: first double-click B2, enter the formula "=ABS(A2)", and press the Enter key; then move the mouse to the lower right corner of the cell, wait until the cursor turns into a black cross, and pull down the formula; finally Save the data and you can change the number to negative with one click.
- excel 11666 2020-07-31 10:55:17
-
- What software do you use to create excel spreadsheets?
- Commonly used software for making excel tables: 1. Microsoft Office Excel, a spreadsheet software written by Microsoft for computers using Windows and Apple Macintosh operating systems. 2. WPS form, a spreadsheet office software released by the domestic Kingsoft company.
- excel 75003 2020-07-29 12:09:20
-
- Why do numbers in excel change to E+18 format?
- Reason: The number is too long; Excel defaults to displaying numbers with more than 11 digits in scientific notation (E+). Solution: 1. Before entering numbers, enter single quotes. At this time, the input cell will default to text format and the numbers will be fully displayed. 2. Set the cell to text format. 3. Set the data to numerical format.
- excel 74551 2020-07-29 11:02:28
-
- How to freeze the second row in excel in wps?
- The operation of freezing the second row in excel in wps: first click to open the excel document; then select the second row of the window to be frozen, and click the [Freeze Window] option; finally click the [Close] option, and click [OK] to save the modified content That’s it.
- excel 21312 2020-07-27 14:33:15
-
- How to change the excel table date into a regular numerical value?
- The solution to convert the excel table date into a regular value: first click to open the [Start] tab; then click the drop-down menu next to [General]; and finally click the short date or long date in the pop-up menu.
- excel 17153 2020-07-27 13:52:34
-
- How to set up pagination printing and typesetting in excel?
- How to set up pagination for printing and typesetting in Excel: first open the document and artificially add a page break; then move the mouse to position the cell where the page break needs to be inserted; then click [Page Layout - Separator] in the menu bar above; and finally click Click on the drop-down menu to insert a page break.
- excel 24294 2020-07-27 11:49:50
-
- What is the default alignment in excel
- Different types of data in Excel have different alignments; for numerical data, the default alignment is "aligned to the right horizontally and aligned vertically"; while for textual data, the The default alignment is "left aligned horizontally, center aligned vertically".
- excel 32637 2020-07-25 11:29:23
-
- What does Excel Unauthorized Product mean?
- Unauthorized Excel products mean that the product has not been purchased. The solution: 1. Log in to the user's Microsoft account, enter the "Personal Center" to purchase and activate as required; 2. Enter the activation key to automatically activate the product; 3. Use alternative product WPS.
- excel 57099 2020-07-24 16:39:12
-
- Why are the columns at the bottom of the Excel table missing?
- Solution to the problem of missing columns under the Excel table: First, double-click the Excel table icon to open the table; then click [File] on the upper left side of the table; then in the file menu, click [Options]; then on the options page, click on the left [View]; finally check [Status Bar].
- excel 18637 2020-07-24 15:21:35
-
- What types of addresses are there in EXCEL? What's the difference?
- Addresses are: relative, absolute and mixed addresses. Difference: In formulas, relative addresses are used, and the reference addresses change with the position during the formula copying process; absolute addresses are used, and the reference addresses remain unchanged during the formula copying process; mixed addresses are used, and those in the form of $A1 and $A2 are "vertical changes." The row number remains unchanged horizontally", and those in the form of B$1 and B$2 are "the column number remains unchanged vertically when changing horizontally".
- excel 17990 2020-07-24 13:37:25
-
- Can Excel exchange data with Word?
- Excel can exchange data with Word. The exchange method is: first open the Word program that you want to share data with; then select the data you want to share to Excel in Word; then select the "Start" menu in the Word program and click " Copy" button; finally paste it into Excel.
- excel 5326 2020-07-24 11:28:30
-
- What is the shortcut key for taking a screenshot of an excel table?
- The shortcut keys for taking screenshots of Excel tables are: taking screenshots (ctrl+alt+x) and hiding the current window when taking screenshots (ctrl+alt+c). Note: In order to avoid the situation where the WPS editing window blocks our view when taking screenshots of other areas on the desktop, you can use the method of "hide the current window when taking screenshots" to take screenshots.
- excel 121981 2020-07-23 15:35:45
-
- What does a mixed reference mean in a referenced cell address?
- Mixed reference means: a referenced cell address contains both absolute cell address reference and relative cell address reference. A mixed reference is a reference between a relative reference and an absolute reference, which means that one of the rows and columns of the cell is referenced, one is relative and the other is absolute. There are two types of mixed references: row absolute and column relative.
- excel 16109 2020-07-23 12:06:11
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
