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 enter the next row in excel?
- How to enter the next line in Excel: 1. After entering a line, press the "Enter" key to jump to the next line. 2. Use the down arrow on your keyboard. 3. Use the shortcut key "alt+enter" to wrap a new line in a cell.
- excel 25623 2020-03-03 10:31:48
-
- How to solve the problem that the excel file icon turns white?
- Solution to the problem that the excel file icon turns white: 1. Run regedit while running. 2. Find FileExts in the registry, and then delete the redundant files.
- excel 52197 2020-03-03 10:26:30
-
- How to create double vertical coordinates in Excel?
- How to make double ordinates in Excel: Right-click the line chart in Excel, select "Format Data Series" in the pop-up menu, and select "Secondary Coordinates" in the pop-up dialog box to generate a double-coordinate chart.
- excel 18218 2020-03-03 10:16:30
-
- How to insert rows in excel table
- How to insert rows in an excel table: first open the EXCEL table that needs to be edited and enter the editing page; then right-click column A and select "Insert"; then right-click a row and select "Insert" to insert in the excel table One line.
- excel 17904 2020-03-03 10:02:15
-
- How to find the difference between two columns of excel data that are partially the same?
- The data in the two columns of excel are partially the same. Find out the different methods: 1. Select the data in the two columns, and then use the shortcut key "Ctrl+" to automatically select different cells. 2. Select two columns of data, turn on the positioning function, and select "row content difference cells" in the positioning conditions.
- excel 11637 2020-03-03 10:02:04
-
- How to manually draw lines in excel
- How to draw lines manually in Excel: 1. Click Insert-Shape; 2. Select the free curve in the line; 3. Hold down the left mouse button and slide where you want to draw the line; 4. You can set the color of the line in the drawing tools menu , contour and other effects.
- excel 20346 2020-03-03 09:54:08
-
- How to use the yearfrac function
- How to use the yearfrac function: first open the excel table; then call the YEARFRAC function and enter "=YEARFRAC"; then set the starting date and daily basis type; finally click Enter to view the ratio of the number of days in the time period to the number of days in the whole year. Can.
- excel 21792 2020-03-03 08:58:46
-
- How to use the weeknum function
- How to use the weeknum function: first open the excel table; then call the function and enter "=WEEKNUM" in the specified cell; then set the date to be calculated; finally, according to the Excel prompts, select Friday as the first day of the week. Just calculate the week number of the date.
- excel 20116 2020-03-03 08:52:11
-
- What is the shortcut key to clear content in excel?
- The shortcut key to clear content in an excel table is the delete key. How to use: Select the data you want to delete and use the delete key on the keyboard to quickly delete it.
- excel 46454 2020-03-02 15:05:53
-
- How to change excel phone number to E+10
- Scientific notation in Excel will be expressed as: number + E + plus sign + number; there is E + 10 in the phone number. Obviously Excel treats the phone number as a number and automatically expresses it in scientific notation. Just set the format, that is The complete phone number can be displayed.
- excel 45348 2020-03-02 14:59:02
-
- How to match multiple columns of data with Excel vlookup
- How to match multiple columns of data in Excel vlookup: first select cell G2; then enter "VLOOKUP($F2,$A$2:$D$7,COLUMN(B1),0)"; finally select precise search.
- excel 36942 2020-03-02 14:45:26
-
- How to quickly add negative sign in excel?
- How to quickly add a negative sign in excel: 1. Enter "-1" in any cell and copy it. 2. Select the number to which a negative sign needs to be added, right-click with the mouse, and select "Paste Special" in the shortcut menu. 3. In the pop-up dialog box, select "Multiplication" in "Operation", and then click OK.
- excel 16271 2020-03-02 14:18:31
-
- How to fix the table header in Excel so that when you pull down the entire table, you can see the table header
- How to fix the header in Excel: 1. Set the header to the first row, and then select the first row. 2. Click to enter the view page, and then click Freeze First Row in the Freeze Pane.
- excel 15810 2020-03-02 13:45:23
-
- What is the shortcut key for selecting all in excel?
- Excel select all shortcut keys: 1. "CTRL+A", click once to select the data area, and click twice to select the entire table. 2. "ctrl+shift+8" selects a continuous area. 3. "ctrl+shift+down arrow" selects all rows in the data area.
- excel 69670 2020-03-02 10:59:47
-
- How to type 'not equal' in excel?
- How to enter inequality in excel: If you use the inequality sign in the formula, enter "<>". If the inequality sign is used in the description, use the intelligent ABC input method and press V1 to turn to the third "≠" on page 4.
- excel 35289 2020-03-02 10:46:27