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 compress font spacing in excel
- How to tighten font spacing in Excel: 1. First select the table, right-click, and select [Format Cells]; 2. Then switch to the [Alignment] tab, check the [Reduce Font Fill] option, and click [OK]; 3. , and finally adjust the table size.
- excel 25391 2020-05-12 17:27:10
-
- How to match data in 2 excel tables
- Methods for matching data in two excel tables: first place the cursor in an excel cell; then enter "=vl" in the cell, and add a "," after the data; then in another table, put all the data Select all; finally fill in the data that appears in the "Sheet1" table in the overall evaluation table.
- excel 27049 2020-05-06 15:22:45
-
- How to output value in excel interval range
- The method of outputting values in excel interval range: first open the table excel file that needs to be filtered; then click Numeric Filter to perform specific data filtering or data filtering for a certain numerical interval for table files containing a large amount of data; then open advanced filtering and enter Cell range or use the mouse to select the required area; finally click OK.
- excel 14718 2020-05-06 15:21:20
-
- What is the extension of Excel 2010 workbook?
- The extension of Excel2010 workbook file is xlsx. How to modify the file extension of Excel 2010 workbook: Open the file whose extension you want to modify, click "File" at the top of the page, click "Save As" - "This Computer" - "More Options" in the pop-up interface, and then open The extension can be modified in the interface.
- excel 17759 2020-05-08 15:18:31
-
- How to check duplicate data in two excel tables
- How to check data duplication in two excel sheets: Enter countif in Sheet1, select the data to be compared, enter a "," sign, then enter Sheet2, select the data to be compared, and press Enter.
- excel 12513 2020-05-09 16:24:15
-
- How to format date in excel into yyyy-mm-dd format
- The method to format dates in excel into yyyy-mm-dd format is: 1. First select the date, right-click, and select the [Format Cells] option; 2. Then switch to the [Number] tab and click [Customize] , select [General Format] and enter [YYYY-MM-DD].
- excel 51451 2020-05-13 17:38:06
-
- How to generate weekday corresponding to date in excel
- The method for Excel to generate the week corresponding to the date is: 1. First, select the date, right-click, and select the [Set Cell Format] option; 2. Then select the format corresponding to the date, and then change the date type in the custom column to [yyyy year] mm month dd day aaaa], click [OK].
- excel 7619 2020-05-13 17:38:52
-
- How to select all cells in a worksheet
- Method to select all cells in the worksheet: 1. Click the blank square at the intersection of the row number and column number in the upper left corner of the worksheet. 2. Select a cell in the worksheet, and then use the "Ctrl+A" shortcut key to select all cells in the worksheet.
- excel 25457 2020-05-09 16:23:05
-
- What does now() mean in excel
- In Excel, now() is a function used to return the serial number corresponding to the current date and time. If the cell format is "General" before entering the function, the result will be in date format.
- excel 12275 2020-05-09 16:22:53
-
- Can worksheets be moved between different workbooks?
- Worksheets can be moved between different workbooks. Moving method: Select the worksheet you want to move, right-click, select "Move or Copy Worksheet" in the pop-up menu, set in the pop-up dialog box to move the selected worksheet to the workbook, and then click OK.
- excel 5714 2020-05-09 16:22:27
-
- What should I do if the scroll bar in Excel is missing?
- The solution to the missing scroll bar in Excel is: 1. First open Excel, click [File], select [Options], and open the [Advanced] option; 2. Then find [Display options for this workbook] and select [Display Horizontal scroll bar], click [OK].
- excel 6420 2020-05-13 17:47:21
-
- How to convert pivot table into table
- How to convert a pivot table into a table: first insert a pivot table, and click the "+" sign in the cell in the first column to expand the table; then remove the subtotal rows in the table; then adjust the table to a table style; and finally, in sequence Click "PivotTable Tools-Design-Report Layout-Repeat All Item Labels".
- excel 35285 2020-04-27 16:38:06
-
- How to display quantity in parentheses after filtering in excel
- How to display the quantity in brackets after Excel filtering: First open an Excel table and select the area to be filtered; then click the "Data" option in the main menu and select "Filter" in the tools; then click "Insert" in the main menu ", select the insert function; finally select the "SUBTOTAL" function and filter.
- excel 37512 2020-04-27 16:36:21
-
- Why does #N/A appear when using the vlookup function?
- "#N/A" will appear when using the vlookup function because there is no matching judgment set. The solution is: first open the Excel file; then enter the "vlookup" function in the blank cell to find the employee; then check the entered formula parameters; finally Just set the matching judgment and save it.
- excel 9208 2020-04-27 16:36:06
-
- How to solve the problem of lost or damaged excel dictionary file
- Solution to missing or damaged excel dictionary file: right-click Excel, select Properties in the drop-down menu, enter the Compatibility tab in the properties dialog box, and check "Run in compatibility mode" and "Run as administrator".
- excel 9784 2020-05-07 11:59:56