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 excel cross cursor
- How to set the excel cross cursor: 1. Select a cell and click the [View] option in the top toolbar; 2. In the pop-up secondary menu, click the [Reading Mode] option. At this point, the cursor will turn into a cross cursor, and we can also set its color.
- excel 53517 2020-06-16 15:16:08
-
- What is the shortcut key for starting a new row in excel?
- The shortcut keys for starting a new row in Excel are: 1. When starting a new row in the table, just press [enter]; 2. When starting a new row in a cell, you need to press the shortcut key [alt+ENTER].
- excel 25179 2020-06-16 14:24:15
-
- How to change the excel cell date format to 2013-01?
- How to change the date format of excel cells to 2013-01: First open the excel file and select the row to be edited; then press [Ctrl+1] or right-click to set the cell format, and select the [Date] option; finally click Auto To define the options, enter [2013-01] in the text box below the type.
- excel 6217 2020-06-16 13:52:08
-
- How to use vlookup to filter duplicate data from two excels?
- How to use vlookup to filter duplicate data in two excels: first add the [auxiliary] column after both tables and automatically fill it with 1; then click [View-Switch Window-Excel Tutorial] in Table 2; finally click sheet6 to switch Just go back to [excel tutorial] to find all duplicate records.
- excel 29148 2020-06-16 11:21:10
-
- What should I do if excel cannot find smartart?
- The solution to the problem that excel cannot find smartart: First, click [Insert Button-Shape] in the excel table; then choose to insert various SmartArt graphics; and finally select the graphics that need to be inserted.
- excel 33461 2020-06-16 10:53:24
-
- What should I do if the number after I enter a number in an Excel spreadsheet changes to 0?
- The solution to the problem that the last few digits of a number entered in an Excel table become 0: 1. Enter the English ['] quotation marks in the cell before entering the number; 2. Select the data cell and click [Format Cell]; 3. In sequence Click [Number-Text-OK].
- excel 42480 2020-06-16 09:54:47
-
- How to restore asterisks to numbers in excel
- The method to restore asterisks to numbers in Excel is: 1. Select the area to be restored and right-click; 2. Select [Format cells] in the pop-up option list; 3. Check [Number] under the column [ General] category, click [OK].
- excel 32967 2020-06-16 09:10:45
-
- How to set excel to only display ready?
- How to set excel to only display ready: first open excel and click [File]; then click [New] in the pop-up; then select the document we want to add; and finally select it and click it.
- excel 6715 2020-06-15 17:48:19
-
- How to set the alignment of two columns with the same name in an excel table?
- How to set up the alignment of two columns with the same name in an Excel table: First, sort the first column in descending or ascending order; then select the second and third columns for custom sorting; then set the custom sorting according to the first column; and finally complete the sorting with the same name. Can.
- excel 25683 2020-06-15 17:38:34
-
- How to separate irregular Chinese and English in Excel?
- How to separate irregular Chinese and English in excel: first open the table, and click [Data, Column] in the table; then click [Fixed Width, Next]; finally click on the boundary between Chinese and English, and a line will appear. Just click Finish.
- excel 19931 2020-06-15 15:15:00
-
- How to round in excel?
- The method of rounding in Excel: first enter the formula ROUNDUP in B2; then select cell A2 in the brackets and press Enter; finally, pull down and copy in the lower right corner of cell B2, and the entire series is completed.
- excel 12212 2020-06-15 14:59:03
-
- What should I do if the menu bar disappears when I right-click in Excel?
- The solution to the problem that the menu bar disappears when you right-click in Excel is: 1. Click the [File] option in the upper left corner and select [Options] in the pop-up option list; 2. Switch to the [View] column; 3. Check Just select the [Show floating toolbar when right-clicking] option.
- excel 27412 2020-06-15 14:30:09
-
- How to prohibit changes in excel after entering data
- How to prohibit changes after inputting data in Excel: 1. Open the Excel table and click the [Review] option in the top toolbar; 2. Click the [Protect Workbook] option in the pop-up secondary menu; 3. Check [Structure] 】 option, enter the password.
- excel 9254 2020-06-15 13:14:24
-
- How to set the expiration reminder in Excel to change color 30 days in advance?
- How to set the Excel expiration reminder to change color 30 days in advance: First select the table column to be reminded, and click [Start, Conditional Formatting, New Rule]; then click [Use a formula to determine the cells to be formatted] and enter [= C1-TODAY()<=30]; then set the font color; finally click OK.
- excel 49809 2020-06-15 12:10:34
-
- How to use date function in excel?
- How to use the date function in excel: first click the insert function button in the table; then enter the date function query and select to enter the settings panel; then enter the year in the year column, and enter the month and date in the lower column; finally, set the cell Just switch the format.
- excel 11958 2020-06-15 12:00:24
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
