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 workbook properties in excel
- How to set workbook properties in excel: first find the Excel workbook to which property values need to be added; then right-click the Excel application icon; then find the properties command in the pop-up right-click menu and click it; finally set each property in a new window Just value.
- excel 13092 2020-03-02 09:36:13
-
- What should I do if the ID card number in Excel displays E+17?
- The solution to the problem that the ID card number displays E+17 in Excel: first right-click on the cell; then select "Format Cell" from the right-click menu; then in the open Format Cell window, click the "Number" option card; finally, select "Text" from the category list in the Number tab and confirm.
- excel 25895 2020-03-02 09:25:42
-
- What should I do if the words disappear after inputting in Excel?
- The reason why the words disappear after inputting in Excel is because the cell font color is set to white. The solution is: first open Excel; then select the cell; then set the font color; finally re-enter the text and it will display normally.
- excel 35300 2020-03-02 09:19:03
-
- How to add 1 to numbers in excel table
- How to add 1 to the numbers in the excel table: first open the excel table; then press and hold the shortcut key [alt+F11]; then open the code window and copy the code "Private Sub Worksheet_SelectionChange(ByVal...") and save it.
- excel 27645 2020-03-02 09:14:09
-
- What to do if rows cannot be inserted in the middle of excel table
- The solution to the problem that rows cannot be inserted in the middle of the excel table: first open the excel table; then right-click the worksheet and select Unprotect the worksheet; then verify the setting results and right-click; finally, the rows can be successfully inserted into the worksheet.
- excel 12082 2020-03-02 09:09:03
-
- How to convert a horizontal table into a vertical table in Excel
- The method of converting a horizontal table into a vertical table in Excel is: 1. First, select the entire table and copy it; 2. Then, create a new worksheet and click [Paste Special]; 3. Finally, click [Transpose]. Click [OK].
- excel 12040 2020-02-29 17:11:40
-
- When opening a file in excel, it shows no response
- The solution to the problem that Excel does not respond when opening a file is: 1. First, click [office]; 2. Then, enter the excel options and find [Add-ins]; 3. Finally, click [COM Add-ins] and uncheck [Chinese] Trantion] option.
- excel 28167 2020-02-29 17:02:08
-
- Excel automatically generates dates
- The method for Excel to automatically generate dates is: 1. First, click [Formula] and [Insert Function] in sequence; 2. Then, enter the function name DATE and click Go; 3. Finally, enter the year value, month value, and date value Just the cell range.
- excel 17677 2020-02-29 16:43:53
-
- Create diagonal lines to separate cells in excel
- The method to create diagonally divided cells in Excel is: 1. First, right-click the cell and select [Format Cells]; 2. Then, add a diagonal border; 3. Finally, fill in the content and add superscript or subscript The effect is enough.
- excel 21795 2020-02-29 16:32:30
-
- How to count the number of the same names in excel
- The method for counting the number of the same names in Excel is: 1. First, select the data content that needs to be counted; 2. Then, switch to the [Data] tab and click [Pivot Table]; 3. Finally, select the data source cell Location, as well as the statistical data location, just check the items that need to be counted.
- excel 19924 2020-02-29 16:02:27
-
- After saving in Excel, can I restore it to the state before saving?
- After saving in excel, you cannot directly restore the file contents before saving. When the Excel file is saved, the original file is automatically replaced by the newly saved file.
- excel 13298 2020-02-29 15:53:48
-
- How to calculate average score in excel
- The method for calculating the average score in Excel is: 1. First, click the [Insert Function] option; 2. Then, select [average] and click OK; 3. Finally, select the calculation area where the average score needs to be calculated, and click OK.
- excel 10299 2020-02-29 15:50:32
-
- What should I do if Excel prompts that the reference is invalid and cannot be closed?
- The solution to the problem that Excel prompts that the reference is invalid and cannot be closed is: 1. First, right-click the taskbar and select [Task Manager]; 2. Then, switch to the [Application] tab and find [Microsoft Excel]; 3. Finally, click [End task] will close excel.
- excel 20266 2020-02-29 15:40:18
-
- How to use shortcut keys in excel to change lowercase words to uppercase words
- The method to use shortcut keys in Excel to change lowercase words into uppercase words is: 1. First, enter the uppercase form of the word in the cell after the lowercase word; 2. Then, press Enter, and then press [ctrl+e 】Shortcut keys are enough.
- excel 13148 2020-02-29 15:31:55
-
- How to set cross cursor in excel
- The method to set the cross cursor in Excel is: 1. First, open the Excel table and switch to the [View] tab; 2. Then, select [Reading Mode] in the view toolbar and set the cursor color as needed.
- excel 39587 2020-02-29 15:13:29
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
